Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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.H...
Need Help
  • GilbertQ's avatar
    GilbertQ
    1 year ago

    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's avatar
    Anonymous
    1 year ago

    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!

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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.