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.
Does anyone know if this process of 'republishing' the reports would affact the URL of that report?
We are using apps to distribute reports and if I need to redistribute a new URL for the report (or app) each time this happens - this will quickly escalate to a major issue.
Hi,
by my experience url of report changes if you delete previous version and then upload new one. If you are just owerwriting old one, it obviously stays the same. Report section's ID's don't change, but Report ID does and that is the problem if you have used links to to join that report with some other. BTW Im having same problem with 2 of my reports and deleting them from workspace would affect dynamic links I'm using somewhere else, so I'm still looking for some other solution..
Zuzka