Microsoft Fabric, Power BI, Analysis Services, DAX, M, MDX, Power Query, Power Pivot and Excel
A quick note for anyone like me who spends too much time looking at the JSON exports from Performance Analyzer in Power BI Desktop: you may have noticed an event called Query Pending that isn’t (as yet) documented in the Word doc that explains the format of these JSON files. It turns out that it’s … Continue reading Query Pending Event In Power BI Performance Analyzer
Back in 2021 I wrote a post showing how you can link a DAX query generated by a Power BI report in Log Analytics to a visual in a Power BI report. In that post I showed how you can get the unique IDs for each visual in a report using Performance Analyzer, an approach … Continue reading Getting Report Visual IDs With Power BI Desktop Developer Mode
If you’re monitoring activity in Power BI, for example using Log Analytics, you’ll know that you can capture the DAX queries generated by your published Power BI reports. How do you make sense of them though? You may want to know which tables, columns or measures are being used by a query – maybe so … Continue reading Finding The Tables, Columns And Measures Used By A DAX Query In Power BI
Why the “visual has exceeded available resources” error occurs in Power BI Desktop and what you can do about it
I don’t have anything against the use of calculated columns in Power BI semantic models in general but you do need to be careful using them with DirectQuery mode. In particular when you have a DirectQuery connection to another Power BI semantic model – also known as a composite model on a Power BI semantic … Continue reading Performance Implications Of Using Calculated Columns In Composite Models On Power BI Semantic Models
Power BI table visuals with a visual-level filter applied may perform worse than expected, and applying the filter inside your measures may improve performance
If you have a slow DirectQuery report in Power BI one of the first questions you need to ask is how long the SQL queries that Power BI generates take to run. This is a more complicated question to answer than you might think, though, and in this post I’ll explain why. I happen to … Continue reading Measuring DirectQuery Performance In Power BI
If you’re using DirectQuery mode for one or more tables in your Power BI dataset, the chances are that you will want to see the SQL (or whatever query language your DirectQuery data source uses) that is generated by Power BI when your report is run. If you can view the queries that are run … Continue reading Capturing SQL Queries Generated By A Power BI DirectQuery Dataset
The integration between Azure Log Analytics and Power BI opens up a lot of new possibilities for Power BI administrators. It’s still in preview (there’s a lot more cool stuff still to come) but the Analysis Services events that are available at the time of writing are still very useful: they give you pretty much … Continue reading Matching DAX Queries To Individual Visuals In A Published Power BI Report
How to run performance tests on Power BI Direct Lake datasets in Microsoft Fabric
