cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NeilBarrett
Advocate II
Advocate II

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 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?

1 ACCEPTED SOLUTION

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

13 REPLIES 13
Zuzana
Advocate II
Advocate II

Hi, 

 

so deleting / re-publishing report was not option for me because of some links we use. At the end I created MS support ticket (in O365 admin centre) and they helped me.

 

In my case the issue was caused by tile in dashboard. After deleting all tiles that originated in my report, manual refresh and even scheduled ones are working again. 

 

Zuzana

You're doing the Lord's Work. Thank you very much, it worked!

Thanks, This option of removing dashboard tiles worked for me without even changeing the link.

 

My guess is even by dropping the dataset and report would have removed the link between dashbaord and report and thats why its working for other's option.

Worked like a charm for me as well. Thanks!

tyler-PBI
Regular Visitor

I've had this problem a few times this past week. That solution clearing the cache and deleting the dataset worked, but I also have the same problem as the Report URL is changing for users each time and frustrating them (and me). This is not sustainable, there must be a more clear problem/solution?

 

I have also started using the app workspace now. I can't seem to delete the data source without unpublishing the app. Does anyone know if I unpublish, the app, delete and replace the data source, then re-publish the app, would the URL and saved dashboards for the app stay the same? I'm trying to champion PBI internally but can't have the remote working CEO with broken links/barriers to implementing this.

 

I can't seem to call or e-mail anyone from Microsoft on this topic? If I try to create a ticker as per suggestion by 

 

Anonymous
Not applicable

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

v-jiascu-msft
Microsoft
Microsoft

Hi @NeilBarrett,

 

I would suggest you create a support ticket here.

create ATicket

 

Best Regards,

Dale

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

This solution worked perfectly for me. 

Thank you!!

I also faced this issue and your solution worked for me...Excellent ..Thanks😊

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

Anonymous
Not applicable

No idea. 

 

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

 

This simply isn't good enough.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!