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,

 

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