Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
shubhamgoswami
Frequent Visitor

Performance issue with customized visual plots

Hi,

I have created a dashboard with custom visual python plots with 5 slicers/filters. Now both desktop and report are taking lots of tiime to load with every filter change (30sec to 1min) for each plots.

I have optimized all the codes to basic level ( removed all the power querry and loops in the code) but still facing the same issue.

Suggestions will be much appreciated.

Thanks alot in advance.

Shabham 

3 REPLIES 3
v-diye-msft
Community Support
Community Support

Hi @shubhamgoswami ,

 

1. Quite often slow queries often relate to poorly written measures. 

You can use DAX Studio to run traces against your measures in your data model to find the issue

https://daxstudio.codeplex.com/

 

2. Also you can take a look at this blog:  http://radacad.com/performance-tip-for-power-bi-enable-load-sucks-memory-up 

3. Try to run the latest Power BI desktop version: https://www.microsoft.com/en-us/download/details.aspx?id=45331. 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Hi @v-diye-msft 

 

Thanks a lot for your suggestions.

 

I have already tried all th above options but still I am facing the same issue.

 

Not only the report file, even PBI desktop is also taking lots of time to load.

 

Your help would be much appreciable.

 

Shubham

Hi @shubhamgoswami ,

 

Please kindly refer to the official article:

https://docs.microsoft.com/en-us/power-bi/power-bi-reports-performance#understand-custom-visual-perf...

 

For a deeper dive into which visuals are taking up the most time and resources, you can connect SQL Profiler to Power BI Desktop to get all full view of query performance.

 

 

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.