Recurring "internal service error" when refreshing dataset

[PiotrStawicki]

Hello,

For 4 days I have a problem when refreshing one dataset - it constantly returns "internal service error" after any try (scheduled, on-demand or OneDrive)

What's important to notice:

- when I download the pbix and refresh it locally, it finished without any problems

- when I published the pbix in another workspace, it also refreshes properly (both on demand and scheduled)

- other datasets in the same workspace also refresh properly

So looks that the problem occurs only for this single dataset in the specific workspace. I detected, that the first failure was after trying to refresh it 9th time during 24h (it's in a standard workspace, so has an 8 times limit). But then I waited full 24h without any refresh to clear the limit, but it didn't help.

PS: I'd like to avoid deleting the entire dataset and publishing it then from the beginning. There are multiple reports based on this dataset, a lot of users have their personal bookmarks saved etc. Would be great to just fix the refreshing disability

Regards!

[lbendlin]

We see this issue a lot, and often it can be traced to the data source being overwhelmed. First you should try disabling parallel loading of tables. If that doesn't help (and if you have a PRO license) you will want to raise a ticket with Microsoft so they can check their logs and advise you on the actual root cause.

[PiotrStawicki · Accepted solution]

Thank you for your answer. Today I finally found the reason on some another thread.

The problem was caused by one of the dashboards based on this dataset. I'm not sure what exactly was wrong, but some tiles were blurred/have some exclamation marks. Deleting them helped also with the dataset refresh 🙂

[lbendlin]

That's a very interesting find. Can you provide more details on the type of error messages shown in the dashboard tiles?