Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Thank you very much!
Import from Excel
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
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.
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |