Getting error "last refresh failed because of an internal service error" which doesn't help

[Addy2020]

Getting this error while refreshing from Service, but it doesn't mention the reson for it not directing me to anywhere. Please help.

"The last refresh attempt failed because of an internal service error. This is usually a transient issue.".

[Anonymous]

Hi @Addy2020 ,

What is the gateway source of your report. Have you tried to reconfigure the gateway source .

In case any connectivity issue is there with respect to your data source with Gateway then it need to be rectified First.

I also intermittently facing such issues but all those are due to Data processing operation is going on at  source end and at the same time report refresh event is occured. 

Detailed message can be seen in report refresh history tab in Services.

Thanks

[Addy2020]

Based on MS support I reconfigured my Gateway & that helped me previously (in a different error though) but this time even that didn't helped.

Refresh history is not giving any detailed error message which could be helpful in debugging, just what I mentioned in Topic tile & some codes.

[v-yangliu-msft]

Hi  @Addy2020  ,

I can't reproduce your actual situation, I suggest you create a support ticket to get better help.

This is the website of create support ticket:

https://powerbi.microsoft.com/en-us/support/

How to create a support ticket in power bi:

https://community.powerbi.com/t5/Community-Blog/How-to-create-a-support-ticket-in-Power-BI/ba-p/6830...

Best Regards,

Liu Yang

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

[Addy2020]

Already created a ticket & they're working on it since more than a week with no success.

[Addy2020]

Tried all those steps but still getting same error.

[v-yangliu-msft]

Hi  @Addy2020  ,

You can try the following operations:

The first:
Download the latest version of Power bi Desktop and republish to Power bi services.

The second:

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.

This is a link to related content, I hope it will help you:

https://community.powerbi.com/t5/Service/Scheduled-Refresh-Failed/td-p/770141

https://community.powerbi.com/t5/Service/The-last-refresh-attempt-failed-because-of-an-internal-serv...

https://community.powerbi.com/t5/Service/Refresh-Failed-Internal-Service-Error/td-p/381780

Best Regards,

Liu Yang

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

[Addy2020]

Thanks @v-yangliu-msft Tried all those steps but still getting same error.