topic Re: Refresh Failed - Internal Service Error in Service

Refresh Failed - Internal Service Error

Anonymous — Thu, 22 Mar 2018 14:48:12 GMT

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?

Re: Refresh Failed - Internal Service Error

Anonymous — Thu, 22 Mar 2018 19:52:10 GMT

No idea.

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

This simply isn't good enough.

Re: Refresh Failed - Internal Service Error

v-jiascu-msft — Fri, 23 Mar 2018 07:41:20 GMT

Hi Anonymous,

I would suggest you create a support ticket here.

Best Regards,

Dale

Re: Refresh Failed - Internal Service Error

Anonymous — Wed, 04 Apr 2018 10:33:13 GMT

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.

Re: Refresh Failed - Internal Service Error

Anonymous — Wed, 25 Apr 2018 16:48:49 GMT

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

Re: Refresh Failed - Internal Service Error

Anonymous — Wed, 25 Apr 2018 20:33:45 GMT

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.

Re: Refresh Failed - Internal Service Error

Anonymous — Thu, 12 Jul 2018 09:27:55 GMT

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

Re: Refresh Failed - Internal Service Error

tyler-PBI — Mon, 22 Oct 2018 22:34:04 GMT

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 v-jiascu-msft , it has me sign in and then re-rirects me to my featured dashboard. Is this because I am not an admin of our Microsoft account?

Re: Refresh Failed - Internal Service Error

Anonymous — Tue, 23 Oct 2018 08:46:30 GMT

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

Re: Refresh Failed - Internal Service Error

Anonymous — Mon, 06 Apr 2020 15:17:38 GMT

Worked like a charm for me as well. Thanks!

Re: Refresh Failed - Internal Service Error

Anonymous — Fri, 24 Apr 2020 11:47:22 GMT

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.

Re: Refresh Failed - Internal Service Error

MaheshDadhich — Fri, 01 May 2020 09:10:34 GMT

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

Re: Refresh Failed - Internal Service Error

cjhenrique — Wed, 05 Aug 2020 10:10:52 GMT

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

Re: Refresh Failed - Internal Service Error

TheBishopEmpire — Fri, 19 Mar 2021 01:41:41 GMT

This solution worked perfectly for me.

Thank you!!

Re: Refresh Failed - Internal Service Error

Janski — Mon, 22 Aug 2022 16:18:23 GMT

I agree. This does not address a root cause, could happen again and makes me wish I'd chosen a Cloud First platform.

Re: Refresh Failed - Internal Service Error

apoprio — Tue, 29 Nov 2022 14:17:59 GMT

It's these types of maintenance that start to question Microsoft's governance.

Try to imagine a big company having this impact on several datasets already used by many departments?

Lamentable the solution !!!

To me, that's really too amateurish!!! 🤔

Re: Refresh Failed - Internal Service Error

apoprio — Wed, 30 Nov 2022 14:02:15 GMT

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... 😂

Re: Refresh Failed - Internal Service Error

PedroHeitor — Thu, 29 Jun 2023 14:37:23 GMT

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.

Re: Refresh Failed - Internal Service Error

Anonymous — Thu, 29 Jun 2023 14:41:41 GMT

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

Re: Refresh Failed - Internal Service Error

JPBTech19 — Fri, 07 Jul 2023 03:19:59 GMT

Yikes!

Followed these instructions to the letter. I tried it on two PBIX files. It completely destroyed the files. Now they won't even load. I keep getting prompted to log in a few times and then it finally just stops opening.

Luckily I had backups of the files.

Beware! Make copies of your files before you try this.