Forum Discussion
Refresh Failed - Internal Service Error
thanks v-jiascu-msft - I did just that. The support desk were very helpful.
The solution in my case was to remove the broken reports from the Online service and re-add them.
1 - Open the report(s) in PBI Desktop and clear the cache (file...options and settings... options)
2 - Refresh the data in the desktop and save.
3 - Open PBI Online and remove the associated dataset(s). Note - you'll need to remove the reports from any content packs before you can remove the reports and data from the online service. Also you might want to make a note of the (failed) refresh schedule you had before doing this so you can recreate it exactly.
4 - Hop back to PBI Desktop and publish the report from PBI Desktop to Online
5 - Hop back to PBI Online and set the refresh schedule back up
6 - Add the reports back into any apps or content packs.
Hope that helps.
I setup multiple refresh times (4). I am now starting to have quite a few dashboards refreshing at the same time and I imagine some can get hung up. I decided to have them reset at different times and this seems to help. Also, if you are using tiles, this could be causing the issue. Delete and run a manual refresh, then the scheduled refresh should go back to normal.
Also, instead of deleting and republishing, you can publish over the existing copy without ever deleting the original one.
Having seperate refresh schedules work for me. I just don't understand the root cause of why this is happening other then the Gateway traffic is not optimized to handle muiltiple users using the same scheduled. A simple refresh on demand resolves this issue.