Forum Discussion

highxsky's avatar
highxsky
Regular Visitor
6 years ago
Solved

Slow queries impact on Power BI user interaction

Hi all,   So I was working on a Power BI project lately and encountered performance issues, more specifically thrashing (my computer was very unresponsive and memory & disk were running nearly 100%...
Need Help
Tips and Tricks
  • mahoneypat's avatar
    mahoneypat
    6 years ago

    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

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi highxsky 

 

Power Query is more like a ETL tool that transforms the data and loads it into the model ( VertiPaq Engine ).

So to answer your question it should not ( or else you are working in direct query mode ).

Designing your data model / dataset / DAX Measures correctly will have an impact on the performance.

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn


 

 

 

highxsky's avatar
highxsky
Regular Visitor
6 years ago

Hi Mariusz,

Thanks for the reply !

 

Regarding data model: I have some tables that I generate in DaX.

The effort is on Power BI and not Power Query then?

If so, then I may want to reproduce these tables, in Power Query only.

 

The reason I ask, is because, on many projects, refresh is only made once a week/month, thus users are totally OK with a longer refresh, as long as UX is reactive.