PBI data refresh times out on PBI service but refreshes successfully on the Power BI Desktop

[maddyu]

Hi Team,

I came across the error below from PBI Service but the same refresh works fine on the PBI desktop. On the PBI service it seems to run for 5 hours before it times out. Same refresh worked fine until last week even from the PBI service.

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

Any suggestions is appreciated. Thanks!

[v-yangliu-msft]

Hi  @maddyu，

Please check if it is caused by the following reasons ：

1.Mismatch between the data types of the keys used in relationships.
2.Improper date formats of the date fields in relationships.
3.(null) values in columns with decimal/whole number data types

Make sure the data types of both the fields in a relationship are same. replace (null) values with 0 for decimal or whole number data types.

For more information，you can refer to this ：Error-the-exception-was-raised-by-idatareader-interface/ 

There are other similar links, hope it will help you:

https://community.powerbi.com/t5/Service/Help-with-Dashboard-Refresh/m-p/2111842?utm_source=dlvr.it&...

Best Regards,

Liu Yang

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

[lbendlin]

If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/