Forum Discussion
Slow loading SSRS Reports
I did find this today,
2021-10-04 07:28:51.9843|INFO|87|ui|AAD returned 'System.Net.HttpWebResponse'. You may need to reregister your application with PowerBI in the RS Config Tool.| RequestID = s_148d59f6-73b7-4ace-a87a-2c1474dc2738
2021-10-04 07:28:51.9843|INFO|87|ui|WebException: System.Net.WebException: The remote server returned an error: (401) Unauthorized.
at System.Net.WebClient.UploadValues(Uri address, String method, NameValueCollection data)
Thats seems strange since I'm not sure how the Power BI Report Server running locally has anything to do with the Cloud version. In any case, I went to the RS Config Tool (Report Server Configuration Manager) , selected Power BI Service (Cloud) and selected UpdateRegistration.
I logged in with my Domain account and when I was finished, it wanted to restart the service.
It took a while to restart the service and there seemed to have been an improvement, but I'll need to check tommorrow after setting over night. Its strange that it gets hung up waiting to authenticate to the Cloud, then it moves on since the page will eventually load. I could see if someone was using the Hybrid Cloud features, but not for just local reports. Seems like a bug to me.
I can also confirm that I do not have my on-prem Report Server instance registered with the Power BI service. From what I read about it, it only allows on-prem report items (i.e. visuals) to be pinned to a hosted service dashboard. This means the performance slowness on initial startup for me was not caused by any kind of link or registration to the cloud. I'm betting on the memory dumping/caching being the cause.
