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.

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.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.

Top Solution Authors