topic Re: August 2018 Update - Power BI Reports infinitely "Loading Data..." in Report Server

August 2018 Update - Power BI Reports infinitely "Loading Data..."

codecae — Wed, 22 Aug 2018 03:02:01 GMT

I performed an update of the Power BI Report Server from March 2018 to August 2018 and am finding now that none of my Power BI Reports are rendering! Instead, the screen shows nothing but infinitely spinning dots and the words "Loading Data..."

I have attempted the workarounds in other discussions but nothing seems to be working! Our environment is using constrained delegation and I am able to test the connections successfully when going to the "Manage"->"Data Sources" page for any given report. There doesn't appear to be any authentication or authorization issues.

I left a report "running" for nearly an hour and nothing is happening -- no errors or anything.. just.. nothing :( Usually these reports run in seconds, as they are running against a high-performance SSAS model.

Anyone have any thoughts on how to get this working?

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

Anonymous — Wed, 22 Aug 2018 06:22:43 GMT

I had the same issue.

I've created a Paginated Report and the SSAS Cube give me data, so I was more confused. So, Windows like, I've restarted the Machine and everything works fine. Hopefully that works also in you enviroment?

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

codecae — Wed, 22 Aug 2018 06:37:16 GMT

I have tried many things, including various ways of performing installations and reboot cycles... even tried repairs, etc. Strangely, it will complete a report occasionally, but very soon after the pinwheel of death returns... and by occasionally, I mean like barely ever... never something that would be considered production ready or even predictable by any means.

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

Anonymous — Wed, 22 Aug 2018 06:39:14 GMT

Do you find anything in the report server logs about the issue?

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

codecae — Wed, 22 Aug 2018 06:41:43 GMT

To rule out anything network related, I installed the March 2018 version again with a fresh metadata repository and the reports run every single time, predictably and up to expected speeds... something isn't quite right about this upgraded version.

Even fresh installations result in the same issue.

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

codecae — Wed, 22 Aug 2018 06:42:11 GMT

The logs do not contain anything alarming.. no warnings or stack traces.

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

Anonymous — Wed, 22 Aug 2018 06:46:22 GMT

I prefer to upon a ticket at microsoft

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

rlbuhtbiadp — Wed, 22 Aug 2018 09:48:29 GMT

We implemented the fix that was affecting the SSRS reports from this post but were still having the same problems with Power BI reports as you are having. Deleting the browser cache seems to fix it.

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

muchinski — Wed, 22 Aug 2018 12:42:42 GMT

Cleaning your browser cache sould solve this issue.

This cache problem was discussed on another thread and this seems to be the last version with this problem.

By the way, there is a note on the announcemnet blog post:

"Please note: For those users who are upgrading their report server from a previous version, we recommend clearing your browser cache before viewing your reports."

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

codecae — Wed, 22 Aug 2018 13:29:53 GMT

We tried clearing the cache but it didn't seem to work. Turns out you have to go into the developer console in ie11 and clear it there as well, which isn't very intuitive for most users.

It does seem to have helped in chrome with little effort. It wasn't so easy to clear the cache effectively in IE11, but I think we may have a workaround. I suspect our team will be soon innundated with support tickets, unfortunately, as many of our users don't even know what a cache is, let alone know how to clear it!

Nonetheless, it appears that there may be an update soon that will address this from the server. Anyone aware of when this update may become available?

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

muchinski — Thu, 23 Aug 2018 09:12:49 GMT

Well, I really know what you mean, but unfortunately, cleaning the cache is the only solution I know for this problem.

I have some hope on the next version (December). There the update would run smoothly, following this comment by mgmeyer
"...Also the cache is a known issue that we fixed in this release however it does require to you do clear your cache one more time, it shouldn't happen in future releases...."
https://community.powerbi.com/t5/Report-Server/June-2018-Release-of-Power-BI-Report-Server/m-p/491670/highlight/true#M7201

Re: August 2018 Update - Power BI Reports infinitely "Loading Data..."

jguerrero — Mon, 15 Oct 2018 17:42:39 GMT

If clearing the chace is the solution, where is the document that explain that?

I had no clue what chace you were talking about, and I am still confused.

Is every customer going to clear their own cache?