Forum Discussion
An Error occured while processing the Data in the Dataset
Hi Everyone, I am getting below error while refreshing the data, Please help me to resolve the error
Thanks for your effort and time
There was an error when processing the data in the dataset.Hide details
| Data source error: | {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Class","detail":{"type":1,"value":"11"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"SQL"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"copscus6sqlsrvprod001.database.windows.net;copscus6sqldbprod001"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2146232060"}},{"code":"Microsoft.Data.Mashup.ValueError.Message","detail":{"type":1,"value":"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding."}},{"code":"Microsoft.Data.Mashup.ValueError.Number","detail":{"type":1,"value":"-2"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"DataSource.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.State","detail":{"type":1,"value":"0"}}],"exceptionCulprit":1}}} Table: All Objects. |
Hi Anonymous
The area you are getting is a time out error, which could possibly be that either the query is taking too long to return, or the table is too large to start returning data before the timeout happens. What happens if you reduce the query in terms of how much data is returning to see if that thenworks?
4 Replies
Hi Anonymous
The area you are getting is a time out error, which could possibly be that either the query is taking too long to return, or the table is too large to start returning data before the timeout happens. What happens if you reduce the query in terms of how much data is returning to see if that thenworks?
Thanks for the reply from GilbertQ, please allow me to provide another insight.
Hi Anonymous ,
You can increase the timout time when connecting to the data source on PBI Desktop.
Below are similar issues that you can refer to.Solved: "Error: DataSource.Error: Microsoft SQL: Execution... - Microsoft Fabric Community
Solved: Microsoft SQL: Execution Timeout Expired Error whi... - Microsoft Fabric Community
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.