How to know PBI running slow it is cause by my data model ?

[Paulyeo11]

Hi All

Today I noice that my PBI running very slow. with my note biook is quit high speed . 

May i know it there a way to check it is due to my data model issue ? or i have import too many data to single one PBI file , which cause the slow down. Hope some one can share to link for me to check where go wrong ?

Paul

[v-xulin-mstf · Accepted solution]

Hi, @Paulyeo11 

I suggest you to use performance analyzer in power bi desktop:

You can also use dax studio:

If you want to learn more about performance analyzer and dax studio, you can refer to this:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

https://daxstudio.org/

Best Regards,

Link Chen

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

[amitchandak]

@Paulyeo11 ,  You need to check a few things, like bi-directional joins. Calculations in Power Query.  If there are too many it can reduce load performance.  How many calculated columns and measures

refer: https://maqsoftware.com/expertise/powerbi/power-bi-best-practices
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.c-sharpcorner.com/article/power-bi-best-practices-part-1/
https://www.knowledgehut.com/blog/business-intelligence-and-visualization/power-bi-best-practices