Forum Discussion

Krish89's avatar
Krish89
Icon for Helper II rankHelper II
6 years ago

Power BI Dataset refersh failing with the error “Microsoft SQL: Execution Timeout Expired"

Hello Power BI Community,

I am getting the error when refreshing dataset in Power BI service with the following error message.

“Data source error: Microsoft SQL: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.. The exception was raised by the IDbCommand interface.”

 

Our datasource is Azure SQL server.

 

Any help on the issue would be appreciated.

 

Regards,

Krishna.

Need Help

7 Replies

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    6 years ago

    Hey Krish89 ,

     

    after you published the report to the Power BI workspace, did you check the connections settings of the dataset? You will find these settings on the refresh schedule page of the dataset.

     

     

    Regards,

    Tom

    • Krish89's avatar
      Krish89
      Icon for Helper II rankHelper II
      6 years ago

      Hi Tom,

      Yes, I have checked the datasource settings and it is configured with the right credentials and the refresh was working a week ago but not getting this timeout eror.

       

      Regards,

      Krishna