performance of power bi

[Anonymous]

Hello,
I have a question about the performance of power bi.
I have data that I load into power bi (no direct query).

My data sets have around 160,000 rows. The calculation of the moving average takes about 20 minutes. In the task manager I see that the calculations are performed in MS SQL server analysis services.

My question: Where are the calculations carried out? In Desktop BI local or in MS SQL server analysis services (remote)?
How can I get power bi to perform the calculations locally?

Friedbert

[v-yanjiang-msft · Accepted solution]

Hi @Anonymous ,

Power BI's DAX engine uses SSAS under the hood to perform all of the in-memory calculations.  If you have fairly complex measurements (especially making use of dynamic date comparisons), you'll see significant CPU/RAM usage.

I would suggest you improve your calculations, go through this article and try to optimize reports then test again: Optimization guide for Power BI - Power BI | Microsoft Docs

And there is a blog to analyze the report performance in DAX Studio you can reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @Anonymous 

It will be happening on your local PC which is what you can see in task manager.

IF something is taking that long I would suggest making sure you model your data so that it is in a star schema so that the query can perform well and fast.