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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.