Forum Discussion
Slow queries impact on Power BI user interaction
When you refresh the data, any slowness you see is due to the queries, but also any calculated columns and calculated tables. If you are seeing slowness when interacting with slicers, navigating pages, etc. that is due to unoptimized DAX measures. Also add some of the SQLBI blogs/videos to optimize your DAX expressions too.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
Thanks for the reply!
I had already checked these links as part of my documenting work on performances, along with Chris Webb's (great) posts.
I may want to re-read more thoroughly these links though, as I assume they provide hints to my question on the relationship between PQuery and PBI.
To me, the relationship was not so obvious: it's different modules (PQuery, PBI interface), with different languages, but part of the same global tool (Power BI).
Furthermore, the thrashing issue I encountered clearly came from Power Query, but had an impact on the UX in PBI (and on my computer, big time...), thus I was tempted to make the connection between the two, as it still occurred when data was not refreshing.
When you refresh the data, any slowness you see is due to the queries, but also any calculated columns and calculated tables. If you are seeing slowness when interacting with slicers, navigating pages, etc. that is due to unoptimized DAX measures. Also add some of the SQLBI blogs/videos to optimize your DAX expressions too.
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat