Estimating DAX Query Completion Time
Usually, DAX queries execute very fast, like flashes in a gold seeker’s pan. Sometimes, however, you could end up with a massive DAX query that takes minutes if not hours. […]
New Search
If you are not happy with the results below please do another search
329 search results for: query
Atlanta MS BI and Power BI Group Meeting on July 11th (Pushing the Query Folding limits with Power Query)
Please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, July 11th, at 6:30 PM ET. For more details and sign up, visit […]
Atlanta MS BI and Power BI Group Meeting on June 6th (How Power Query Thinks)
Please join us online for the next Atlanta MS BI and Power BI Group meeting on Monday, June 6th, at 6:30 PM ET. For more details and sign up, visit […]
Power BI Dynamic M Query Parameters Reloaded
In a previous blog from October 2020, I ranted about the narrow list of data sources supported by Power BI Dynamic M query parameters. The February 2022 update of Power […]
DirectQuery Performance Progression
So much data, so little budget! Caching data in Power BI gives you the best report performance, but budget constraints usually put downward pressure to stay within lower Power BI […]
Power BI Dynamic M Query Parameters – Another Opportunity Missed for DirectQuery Users
UPDATE 17-Feb-2022: Dynamic query parameters now support popular relational data sources, and I posted an updated blog. I had recently a Power BI advisory engagement for a large ISV. They […]
Power Query Merging on GUID Columns
Scenario: You are merging two tables in Power Query on GUID columns with Text data type. In my case, the first table (UserDim) came from Azure SQL DB and the […]
Multi-level Column Unpivoting with Power Query
An interesting challenge today come up while mentoring finance users in Power BI. Consider the following Excel layout. The user wants to unpivot the data by rotating the three header rows […]
Implementing Input Table in DAX Query
Scenario: If you want to pass an input table to a DAX query. For example, you might have an application that lets the user specify a subset of customers and […]
T-SQL, Power Query, or DAX?
I taught my Applied Power BI class last week to a group of smart data analysts. All of them were knowledgeable of T-SQL, which they have been using extensively for […]
Follow Us
Prologika is a boutique consulting firm that specializes in Business Intelligence consulting and training. Our mission is to help organizations make sense of data by applying effectively BI technologies.
