Power BI Responsiveness and Performance
Hello, We run a Power BI RS configuration on our domain. This setup was recently updated from the October 2020 build to May 2022. After the update the users have been reporting the following and I wanted to see if there was a way to improve the performance of Power BI. We cannot go to a pbix file and open it. We have to open the application first from the desktop, then use File --> Open. If we try to open a file directly, the PBI icon comes up and it hangs there. It takes several minutes for the PowerBI application to open from desktop. Once a pbix file is open, another one will not open. It starts to open--the PBI icon displays--but it never does open. Similar to bullet 1. This is whether or not we try opening the file directly or use the File menu. Closing a file works fine but we get a message a few minutes after closing that PowerBI has crashed. Power BI RS runs on a Windows Server 2016 VM. The VM has plenty of resources dedicated to it, the memory and CPU are never maxed out.
Report renders very slow
Hello, The PBI report takes >30sec to render, this is too slow (using Edge, Chrome is the same slow). Posting the problem in this section as we have on-prem Report Server. After 4-6 sessions with Microsoft, with them obtaining various run logs from us, we are informed unless we have a break to fix problem, Microsoft support cannot help us 😞 The PBI report has the following visuals and Data Connect Mode is Import (about 200 data rows - few seconds to refresh daily ). 1) 1 Bing Map of North America 2) 1 Area chart 3) 4 Slicers and 1 Text Filter 4) 9 Images 5) 18 Advanced Cards (We have the latest May2021 Report Server) The Model in the report is a star-schema. Performance analyzer showed the max DAX query is only 43ms, Visual display and Other are high ones. Current PBI Server is a 4core CPU and max CPU peaked at 58% only (PBI Server, DB and Web all in the same VM). Microsoft said adding CPU would not make a difference. I am trying to trace with the DevTool (F12) in Edge, the 'reportServerHost.js' took 15sec and many processes have long stalled/waiting states. Don't understand what it all means, thinking maybe this can help explain the slow report render. I am hoping the PBI community can help explain or have suggestions on how the report could be improved for render performance. Thank you. Btw, I did another test with a report that just displays 'Hello' (no DB). It took 8sec to load in the browser.
Reports sometimes taking 60+ seconds to load (SSAS live connection)
Hi, We have an issue on our server where reports are sometimes taking a long time to load. This usually happens when the server has been idle for a period but it may happen when a new user loads reports for the first time (it's hard to test due to sporadic nature). This happens on datasets that are regularly processed as well as those that aren’t. The DAX queries are simple and it's a refined model we've used for years, no issues in Power BI Desktop. In SQL Profiler I can see the following events and timings when the report is loading. Discover End - 56 Seconds Audit Logout - 56 Seconds Query End - 52 Seconds Query End - 52 Seconds Query End - 52 Seconds Query End - 52 Seconds In IE and Chrome using development console I can see the above queries, either with a 'Stalled' or 'Waiting' timing message. Prior to this there are a series of 401 errors, this may be a red herring as these are only visible in IE. The issue is present regardless of browser. I've disabled Loopback Check on the server to remedy the potential authentication issues above. I've also setup a job which runs every two minutes and sends queries to the Tabular Model - unfortunately this doesn't seem to keep the data 'warm'. There are no notable entries in PBIRS logs either. The server is a Zeon E5-2560 4 Core with 48GB of RAM and Enterprise SQL, error present on older and latest version of PBIRS. Using Perfmon I can see we're no where near any memory limitation in SSAS and should be caching everything. I'm not really sure what else to try, any feedback greatly appreciated.
