This blog post explains how to handle the parent child hierarchy in Power BI. If you come from SQL background, then you might be familiar with Parent Child hierarchy scenarios.…
Dynamic Measure Names (Titles) using Field Parameters – Power BI
This article covers how you can use Power BI field parameters to handle measure names dynamically. The solution is simple and effective. I have covered this topic already on my…
Power BI – Careful with DateTime and Date Data Types in Model
This article explains the importance of the Date and DateTime data type change in Power BI. Sometimes, you see column with date as value but it may not be in…
Call Microsoft Fabric / Power BI APIs without Azure APP (SPN – Client ID) using Power Automate
This article is about how to call Microsoft Fabric and Power BI APIs in Power Automate without using the Service Principal (SPN). I mean without having the client ID and…
All About Semantic Model Refresh Activity in Microsoft Fabric Pipeline
This article explains about how the latest feature in Microsoft Fabric Pipelines “Refresh Semantic Model” works and the new possibilities with this feature. This is one of the most requested…
Different Methods to get DAX queries from visuals or from table columns in Power BI
This blog post covers that what are the ways that we can extract the DAX query from a visual or from a selected columns and tables with filters. This will…
Rebind (Switch) Reports to different Power BI Semantic Model
This blog post explains how to switch the report pointed to semantic model 1 to different semantic model without loosing the report configurations like GUID, subscriptions etc. Let me explain…
Vertipaq Analyzer inside Power BI Desktop DAX Query View
The majority of you are likely aware that Power BI utilizes a Vertipaq engine for data and query processing within the platform. To understand and improve the performance of the…
How to use Execute Queries DAX Power BI REST API?
This article explains you how to execute a DAX query using Power BI REST API. As you might aware that we have a dedicated Power BI REST API to call…
Automate On Demand Refresh for Power BI Semantic Model using SharePoint!
This blog post explains how to perform ad-hoc datasets refresh automatically in self-service Power BI model-based organization. Most of the time, Administrators may look for an option to automate this…