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.

     

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.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Pedro, I believe the issue is with the data model, not the report. It's not very fun if you have to remove and replace the data model if you have multiple reports built on it. Sorry.

Tim