Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Refresh failed: Invalid connection credentials

Hi, In my Power BI Report, I am using SQL server as Data Source and this is hosted on Azure. In Power BI Desktop, I am able to connect with server and retrieve data as well. I also tested connection...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

 Hi Anonymous

Thanks for your response.

Database is on premise SQL which install in azure VM. For schedule refresh, I have created cluster gateway on Power BI app and add Data Source under Gateway. Test Connection is successful for this Data Source but when we are trying to refresh/schedule refresh, this gives error as I mentioned. 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Anonymous,

 

Can you please share a snapshot of your datasource setting and gateway connection?

 

If you have multiple available gateways, please double check on your dataset setting to confirm which gateway you used to handle the refresh operation of that  dataset.

 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Anonymous

    screenshot -

    Data Source SettingGateway Setting

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi Anonymous,

       

      I mean gateway connection and data source credentials at 'settings -> datasets'.

       

      In addition, is there any advanced operation in your query? (e.g. merge, append, combine, invoke custom functions...)

       

      Regards,

      Xiaoxin Sheng