Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

PowerBI Service Scheduled Refresh Errors

The Scheduled/On Demand Refresh is erroring on a particular Azure SQL Database.

Other Databases within the same elastic pool are refreshing with no issues.  Below is the most recent few errors.

 

Something went wrong
There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
Data source error: The operation was cancelled by the user.
Cluster URI: WABI-WEST-US-redirect.analysis.windows.net
Activity ID: fe4dfb6a-9afc-45f5-8d9d-63bbcef2b13e
Request ID: 4f5ea68c-38ed-442d-b546-8aeac5c29ce4
Time: 2019-04-26 12:23:34Z

 

 

 

4/25/2019, 11:42:56 AM4/25/2019, 12:00:06 PMFailedThe last refresh attempt failed because of an internal service error
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:06738bde-13ef-4cd1-b2b8-2a5a92e09aeb
Request ID:06ec5695-0bd2-63e6-ade4-c3f998d153fb
Time:2019-04-25 17:00:06Z

 

4/25/2019, 7:01:52 AM4/25/2019, 7:54:26 AMFailedThe last refresh attempt failed because of an internal service error.
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:699237ea-af46-43dc-8d80-fecda9641812
Request ID:532c6a1d-6d6f-4a81-98f1-dcc7d4e3345d
Time:2019-04-25 12:54:26Z

 

4/24/2019, 8:55:10 AM4/24/2019, 9:15:21 AMFailedThe last refresh attempt failed because of an internal service error.
Cluster URI:WABI-WEST-US-redirect.analysis.windows.net
Activity ID:06738bde-13ef-4cd1-b2b8-2a5a92e09aeb
Request ID:fa2c9a81-57d6-7866-c4dd-63d14663d634
Time:2019-04-24 14:15:21Z
Status: New
Comments
v-qiuyu-msft
Community Support

Hi @the1dataninja

 

From internal trace, I found the error"This error often happens after the HierarchyLevel, Hierarchy, or Entity was renamed or deleted. Please update the query/visual to use the new name or undo the name change.". Please check if any changes made to the SQL database recently. 

 

I would suggest you download the report and open it in Power BI desktop, click on Refresh button to see if any error occurs. 

 

Best Regards,
Qiuyun Yu