Forum Discussion

Udayreddee's avatar
Udayreddee
Microsoft Employee
5 years ago

Refresh failing

Hi, I am trying to perform a scheduled refresh. The data sources are SQL SERVER and few CSV/EXCEL files. The refresh takes a really long time and has been failing always. Using OAuth2 authentication...
Need Help
Fowmy's avatar
Fowmy
Super User
5 years ago

Udayreddee 

Please expand the error message and check the reason for the failure. 

 

 

Udayreddee's avatar
Udayreddee
Microsoft Employee
5 years ago

Error Detail.
{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The credentials provided for the SQL source are invalid.

 

This is the error message i got.

  • Fowmy's avatar
    Fowmy
    Super User
    5 years ago

    Udayreddee 

    As per the error message, the cause seems to be the incorrect credentials, please re-check the credentials and try.

     

    • Udayreddee's avatar
      Udayreddee
      Microsoft Employee
      5 years ago

      The credentials which i have given are correct but still getting same error.

       

      Refresh works fine in Power BI desktop but Fails in Power BI service.

       

      I have also parallely set up for Incremental refresh on other dataset, from then we are facing this Issue, before schedule refresh was working fine.