This blog explains what are the other DAX scripts which can be considered as handy for you to understand the model and help you to optimize. I have already shared…
DAX Query View – Vertipaq Analyzer Scripts with URL support
You can use Vertipaq Analyzer DAX scripts in DAX query view to get the details directly in Power BI Desktop DAX Query View or in Power BI service. Detailed article…
Parent-Child Hierarchies in Power BI – DAX
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…