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
Hi, highxsky
I wonder what connection mode you are using. For import mode, upon load, all of the data defined by those queries will be imported into the Power BI cache. Upon building a visual within Power BI Desktop, the imported data will be queried. The Power BI store ensures the query will be fast. All changes to the visual are reflected immediately. Any changes to the underlying data aren't reflected in any visuals. It's necessary to Refresh to reimport data.
For DirectQuery mode, upon load, no data is imported into the Power BI store. Instead, upon building a visual within Power BI Desktop, queries are sent to the underlying data source to retrieve the necessary data. The time taken to refresh the visual depends on the performance of the underlying data source. Any changes to the underlying data aren't immediately reflected in any existing visuals. It's still necessary to refresh. The necessary queries are resent for each visual, and the visual is updated as necessary.
For further information, please refer to the following documents.
About using DirectQuery in Power BI
Optimization guide for Power BI
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.