Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

0
maddyu

Issue refreshing the DataModel from Power BI Service

Submitted by on ‎03-06-2022 11:13 AM

Hi Team,

 

The datamodel we set on refresh to schedule has been running successfully past 1 month and started to fail this week with below error. Tried multiple things but the refresh fails after 5 hours on the PBI service. However, it refreshes successfully on the PBI Desktop within an hour. The dataset is large and connected to Databricks. Any suggestions is appreciated. Thanks!

 

 

<pii>DataSource.Error</pii>: <pii>ERROR [HY000] [Microsoft][Hardy] (35) Error from server: error code: '0' error message: 'Invalid OperationHandle: OperationHandle [opType=EXECUTE_STATEMENT, getHandleIdentifier()=8e521844-6949-4859-b3c2-b8fb4b81dd78]'.</pii>. . The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action. 

 

Status: Delivered
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎03-06-2022 10:10 PM

Hi @maddyu ,

 

 

This issue has been submitted internally with ICM 292038704

 

Problem description: Cx facing error - The Report refresh which was working fine started to fail all of sudden and republishing it to power Bi service and refreshing again didn’t resolve the operation timed out issue.

 

The product team will be investigating this issue and once any updates are available, I will sync the information for you here.

 


Best Regards,
Community Support Team _ Caitlyn

Anonymous
Not applicable
‎03-21-2022 07:31 PM

Has been fixed in  3.1 train.

Idea Statuses