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 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 »
Last year I was working on a requirement, to implement event-based dataset refresh that can send out an email when the refresh has completed successfully or failed. I came across Power Automate as the tool of choice to achieve this task easily and efficiently. Power Automate becoming main stream into Power BI visual does speak
Event-based Power BI dataset refresh with email notification Read More »
In this blog post, I will be showing the Power BI web service settings for implementing Power BI REST API using Service Principal and Sample Powershell script. This is a continuation of previous blog post “Power BI REST API using Service Principal – Part 1“. Power BI web portal settings In order to perform these
Power BI REST API using Service Principal – Part 2 Read More »
