cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ry22749 Frequent Visitor
Frequent Visitor

Performance Analyzer "Other"

Hello,

 

I have a very simple file that has a lot of Visuals and takes like 3 seconds to refresh when I use a slicer. When I run Perfomance Analyzer what it takes more is "Other", what does this mean? How can I reduce the time?

 

Perfomance.JPG

 

Thank you very much!

4 REPLIES 4
Super User
Super User

Re: Performance Analyzer "Other"

@ry22749 hope this post help.






Did I answer your question? Mark my post as a solution.

Proud to be a Datanaut! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.





Community Support Team
Community Support Team

Re: Performance Analyzer "Other"

Hi @ry22749,

How do you connect to the data? Import or direct query?

Best Regards,

Teige

ry22749 Frequent Visitor
Frequent Visitor

Re: Performance Analyzer "Other"

Import from Excel

hnjames9 Frequent Visitor
Frequent Visitor

Re: Performance Analyzer "Other"

Question @parry2k - having similar issue. Second executions are much faster, but initial load is incredibly slow. Using Import for data sources. From the referenced post, is this truly the only thing we can do (reduce number of visuals or dataset) to reduce initial load time because of the load on allocation of structures in memory? Thanks for any help!

 

--- from the post discussed above

  • Other: this is the time spent waiting for other operations to complete. This is typically synchronization time between different visuals in the same page and should not be considered as a bottleneck of the visual being analyzed. It is usually waiting time caused by other pending operations performed by other visuals.

If you compare the duration of the first execution of the Sales page with the second execution, you can see that the latter has a shorter duration because it reduced the Other duration of each visual. The reason is that the first execution of visuals and queries to the data model requires an allocation of new structures in memory; it cannot be reduced unless you reduce the number of visuals and the size of the tables of the data model. For this reason, you should focus mainly on the Duration timing generated when you click on Refresh visuals. This way, you ignore the initial loading time of both report and data model.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors (Last 30 Days)