Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.