Forum Discussion

sgallo's avatar
sgallo
Advocate V
2 years ago

Multiple connection error when refreshing dataset

Hello,

This morning all my data sets failed to refresh. This also happaned when i tried to manually trigger the refresh.

Below the error message I received via email:

I have checked the Fourth_DimEmployees table but on the SQL server all looks good. 

Also, when I manually tried to refresh it, I got the error from another table.

 

When I try to see the raw data in PowerQuery, it times out while refreshing the page:

 

Finally, I did not make any changes to the dataset in the last 2 weeks.

So very strange to get this error.

 

If anyone has any idea on how to fix this or if it is an issue with Microsoft, please let me know

 

1 Reply

  • JoeBarry's avatar
    JoeBarry
    Solution Sage

    Hi sgallo 

     

    Open Power query go to Source in Applied Steps and add this code at the end of the URL

    , [Timeout=#duration(0, 1, 0, 0)]))