Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Refresh Failed - Internal Service Error

  Yesterday I updated PBI Desktop, made some changes to 5 reports and republished them all. Of the 5 reports re-published 4 of them are set to use refresh schedules. The refresh started out ok but s...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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.

     

apoprio's avatar
apoprio
Advocate I
3 years ago

In our case...
We verified that this happens when we have a Dashboard related to the Dataset and that in this Dashboard there is an error!!!
When we deleted the Dashboard and it started working again... ğŸ˜‚

PedroHeitor's avatar
PedroHeitor
Frequent Visitor
3 years ago

Hi!

This seems more close to the root cause that anything I could find on the internet.

How you identify the dashboard with error? I have a lot dashboard conected to the same dataset, I think it's possible that one of them has a error, but I really don't know how to identify that.