cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Fragan
Helper III
Helper III

Troubleshooting visual performance

Hey,

 

I have some visual with high loading time.

 

The visuals Data are calculated using DAX.

 

When using the performance analyser the Dax Requests loading time looks fine (around 150ms overall) but the "Others" loading time is too high (around 5000ms overall), what may be the problem ?

 

image.png

 

Regards.

1 ACCEPTED SOLUTION

Please consider some of these solutions ....

 

Try use 7 of less visuals on a page. The more visuals you use, the slower a page will be.

 

Test each visual separately on an empty page with the performnace analyser, if one of them is especially long then try imporve it or avoid sharing it on pages with other visuals if you know it will delay the whole page. 

 

Try reorder the visuals in the selection window. This might triger the visuals to execute in that order ???

 

See https://www.sqlgene.com/2019/09/27/a-comprehensive-guide-to-power-bi-performance-tuning/

View solution in original post

3 REPLIES 3
speedramps
Skilled Sharer
Skilled Sharer

Hi Fragan

 

Please consider this solution ....

 

Copy the visual to an empty page and try the performance analyser again.

 

The reason I suggest this is because I gather high "Other" can be caused by waiting time for other visuals.

 

If the "Other" is still high, then try post an example for the techy community to see.

 

Oh yeah you're right.

 

Is there any solution to make the visuals not wait for each others?

Please consider some of these solutions ....

 

Try use 7 of less visuals on a page. The more visuals you use, the slower a page will be.

 

Test each visual separately on an empty page with the performnace analyser, if one of them is especially long then try imporve it or avoid sharing it on pages with other visuals if you know it will delay the whole page. 

 

Try reorder the visuals in the selection window. This might triger the visuals to execute in that order ???

 

See https://www.sqlgene.com/2019/09/27/a-comprehensive-guide-to-power-bi-performance-tuning/

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Kudoed Authors