The last refresh attempt failed because of an internal service error

[amenconi]

Hello, as of a couple days ago I now get errors when trying to refresh my dataset.  No problems were reported with data gateway but I have updated that to latest as part of trying to troubleshoot this.

Here is the error received when trying to refresh dataset from web portal:

The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support.

Please try again later or contact support. If you contact support, please provide these details.

Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net

Activity ID: 57f47c64-733f-4b8f-b7c5-88f41cb3c02b

Request ID: bdfa56b7-e4c3-b8a3-4f6d-90c16ff57d3b

Time: 2022-09-28 14:15:17Z

Any help figuring out what may be going wrong would be much appreciated.  Doesn't seem to be a transient issue sinc it's happen a dozen times or more in last couple days of trying to refresh.

Thank you.

[v-cazheng-msft]

Hi @amenconi,

What’s the data source and connection mode of your report? If you refresh by on-demand refresh, will you see the failure as well? If you download the pbix file from the report dataset and refresh from Power BI Desktop, will you refresh successfully? If you check in Power Query Editor(Transform data), will you see any warning or error?

Best Regards,

Community Support Team _ Caiyun

[amenconi]

Hello Caiyun,

Data source uses a data gateway from our SQL Server.  On-demand and scheduled refreshes were not working online, refreshing dataset from desktop worked every time.

I ended up finding this post: https://community.powerbi.com/t5/Service/Refresh-Failed-Internal-Service-Error/m-p/381780

Applying these steps seems to have worked:

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.

Thank you!