An error occurred while processing the data in the dataset.

[AndreH1966]

xxxx, has failed to refresh.
Failure details: 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.

This error has been occurring since Saturday and affects various datasets. Up to now, a total of about 50 updates could not be carried out.
Can anyone tell me what the problem is?

[AndreH1966]

Hi,
Yesterday the updates ran again as planned, this morning there were again 15 messages about failed updates. For all errors, the error details indicate that it is an internal service error and that this is only a temporary problem.
I look after all the PBI datasets and reports in our company. You don't think I'm going to follow the procedure you suggested for the current 15 reports. Make sure that it runs as it did before and eliminate the error. Because one thing is clear, I have not changed the datasets and reports, PBI Desktop is always up to date. I have checked individual reports on my desktop and updated them without any problems, it is only in the service that problems occur. I expect the error to be corrected.

[v-zhangti]

Hi, @AndreH1966 

You can try the following methods:

A. Download the latest version of Power bi Desktop and republish to Power bi services.

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

Best Regards,

Community Support Team _Charlotte

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

[AndreH1966]

Hi,
The solutions suggested have all been useless, except for a lot of work. I've received over 150 emails this week with failed updates, and each one says it's an internal service error that's only temporary.
If it was just a report that I had recently changed, then I would understand or look for the error in the report. However, it now affects 14 datasets with about 50 associated reports.
Can you imagine how I constantly have to justify myself for something I can't do anything about?
I expect you to work on this problem, because it is a problem and not a challenge.
My guess is that it has something to do with the gateway, but I don't have the authorisation for that, it's controlled centrally in our company.
I hope for a solution soon
Best regards
Andre

[AndreH1966]