cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PiotrStawicki
Frequent Visitor

Recurring "internal service error" when refreshing dataset

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!

error1.pngerror2.png

1 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 🙂

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

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.

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 🙂

View solution in original post

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

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!