An Error occured while processing the Data in the Dataset

[Anonymous]

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.

[GilbertQ · Accepted solution]

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?

[Anonymous]

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

Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. - Microsoft Q&A

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.

[Anonymous]

Hi , there is no time limit set to this query, actually, the view I am referring for the report is bit slow, thank you for your effort!

[GilbertQ · Accepted solution]

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?

[Anonymous · Accepted solution]

Hi, you are correct. the query is taking long to load the data, going to re-create the view

Thanks for your time and effort!