Recently Snowflake introduced a Unistore and Hybrid tables in their June 2022 summit. This can be a game changer in the world of data where we separate transactional (OLTP) and Analytical (OLAP) systems. When we are talking about transactional systems it’s about databases whose response time is in milliseconds and able to run millions of […]
What is Snowflake Unistore and Hybrid tables? Read More »
What’s Query folding? Query folding is the ability of Power Query (i.e. Mashup engine) to generate a single query with all the required clauses and filters. This single query is used to retrieve and transform the source data. Why is it important? It pushes the complex transformation to the source. As you get the required
How to check Query folding in Power Query? Read More »
What’s Synoptic panel visual and its uses? Imagine you have a requirement to provide analytics on store, warehouse, parking, or office floor plan visualization within the Power BI report. The floor plan should be embedded in Power BI and when the end-users click on a specific part of the floor plan the report should interactively
Exploring Synoptic panel visual in Power BI Read More »
What’s an On-premise Data Gateway? When to use it? On-premise Data Gateway as the name suggest it’s a Gateway or hub to connect on-premise data sources to Microsoft cloud services like Power BI, Power Apps, etc. You will need to use the Gateway if you are dealing with an on-premise data sources. Cloud data-sources usually
Everything you need to know about the On-premise Data Gateway Read More »
In this blog post I will be implementing a simple web scraping using Power Automate Desktop (RPA) tool. There are some use cases when you will need to scrape or extract data from the website for analytics purposes. For this post, say you have a requirement to know whether the US stock market is overvalued
Web Scraping using Power Automate Desktop – S&P 500 P/E ratio Read More »
In most cases you will want to have scheduled or event-based refresh, but there are some cases where you will want end-users to refresh the Power BI dataset. The main objective of Power Platform is to democratize the data so with Power Automate visuals integration into Power BI makes this becomes possible by giving power
In my last blog post “Integrate Powerapps in Power BI report to achieve write-back ability“, we learned how to integrate Power Apps with Power BI by linking columns to achieve write-back functionality. Now say you have linked 2 columns from Power BI to Power Apps visual and then created the App in Power Apps portal.
How to add/ remove the columns linked between Power BI and Power Apps? Read More »
Most of the clients love interactive Power BI reports and all the capabilities it brings for the end-users. But there are situations when the users want to have the write-back ability from the reporting platform. For example, I am using Microsoft’s sample report: Customer Profitability. Say, you are the CFO of the company and you
Integrate PowerApps in Power BI report to achieve write-back ability Read More »
Recently I was working on end-to-end implementation of Power BI DevOps that includes Gateway, Workspace and Dataset configuration programmatically using Powershell and Power BI REST API. One of the first steps, I stumbled upon was Gateway configuration and how its linked to data sources and dataset settings. Problems How to map or bind data source
How to perform Power BI On-prem Data Gateway management using Service Principal? Read More »
One of the challenges I was facing recently was about a requirement to implement source control and CI/ CD pipeline with existing Bitbucket and Bamboo architecture without using deployment pipelines for Power BI. I would recommend this approach only if deployment pipelines is out of question for your team. Obviously, we cannot have source control
How to implement Source control and CI/ CD for Power BI? Read More »
