Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Refresh Failed - Internal Service Error

‎03-22-2018 07:32 AM

 

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 since then 2 of the changed reports (plus another one I haven't changed) started to fail to refresh beginning around 5 hours ago.

 

The error I get is "The last refresh attempt failed because of an internal service error."

 

Technical Information:

Activity Id: 2f9c5f94-7f1d-48ee-bf5d-cb39a0656c23

Request Id: 0aab327c-e8c3-49e3-81ba-6ae66493025b

Cluster Name: WABI-WEST-US-redirect.analysis.windows.net

Refresh Start Time: 03/22/2018 13:01:14Z

Refresh End Time: 03/22/2018 13:06:02Z

 

I've tried republishing the failed reports again (which worked on another thread) but this doesn't help. I've resubmitted data source credentials in the refresh schedules, this also doesn't work.

 

Any suggestions on what to try next?

Labels:
Message 1 of 23
111,117 Views
1 ACCEPTED SOLUTION
Anonymous
Not applicable
In response to v-jiascu-msft

‎04-04-2018 03:33 AM

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.

 

View solution in original post

Message 4 of 23
111,727 Views
22 REPLIES 22
Anonymous
Not applicable
In response to Anonymous

‎04-25-2018 09:48 AM

This worked for me also. I wish it wasn't necessary, but glad to get around it.

Message 5 of 23
97,274 Views
0
Anonymous
Not applicable

‎03-22-2018 12:52 PM

No idea. 

 

I've had the same issue several times this week.

 

This simply isn't good enough.

Message 2 of 23
76,552 Views

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

View All