cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kumarsandeep Frequent Visitor
Frequent Visitor

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 by SSMS which is successful. I published this report and tried to refresh on Power BI service. But this time DataSet is not refreshed and error is "Invalid connection credentials".

I checked Data Source setting in Gateway and there connection is Successful.

Tried multiple ways but not able to refresh on Power BI app. Please advice what I need to do to fix this issue.

 

Capture.JPG

5 REPLIES 5
Community Support Team
Community Support Team

Re: Refresh failed: Invalid connection credentials

HI @kumarsandeep,

 

How did you host your database? On premise sql database install in azure VM or azure sql database? 

 

If you mean on premise SQL install in azure VM, you need to use gateway to manage this datasource.

 

If you mean azure sql data source, you only need to update your credentials on service side. ('settings -> datasets -> data source credentials')

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Highlighted
kumarsandeep Frequent Visitor
Frequent Visitor

Re: Refresh failed: Invalid connection credentials

 Hi @v-shex-msft

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. 

Community Support Team
Community Support Team

Re: Refresh failed: Invalid connection credentials

Hi @kumarsandeep,

 

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
kumarsandeep Frequent Visitor
Frequent Visitor

Re: Refresh failed: Invalid connection credentials

Hi @v-shex-msft

screenshot -

Capture2.JPGData Source SettingCapture.JPGGateway Setting

Community Support Team
Community Support Team

Re: Refresh failed: Invalid connection credentials

Hi @kumarsandeep,

 

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

6.PNG

 

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

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 326 members 3,190 guests
Please welcome our newest community members: