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

Invalid connection credentials Refresh issue

Hi,

 

I've created two reports in power bi and published them to power bi online. I've also created an on premise data gateway on a device that is constantly running and added the corresponding gateways to the cluster in power bi online.

 

When I refresh the data online in report 1, the refresh runs without any issues. When i run a refresh on the report 2 i get an error back saying "Invalid connection credentials."

 

Apart from a different server name, the only difference that exits is that in edit permissions on power bi desktop, report 1 has the "Encrypt connection" option selected and report 2 doesn't.

 

Both files refresh and update in desktop but report 2 online provides the "Invalid connection credentials" error.

 

Any help would be appreciated

1 ACCEPTED SOLUTION
eamonnde
Frequent Visitor

Hi Tim,

 

Our issue seemed to revolve around the certificate not have the server name, we added it and it worked for us.

 

Apologies for the delay in response.

Eamonn

View solution in original post

10 REPLIES 10
LH1
Helper II
Helper II

Having the same innexplicable issue and unsurprised that after reading this entire thread, theres:

 

1. No clear reason as to why this is happening (Something vague about a certificate?)

2. No obvious solution

 

Will keep digging I guess

Leecal123
New Member

I'm currently connecting to a web data source using API Key passed as a header in my URL. Works fine in PowerBI desktop.

 

I'm trying to create scheduled refresh using personal gateway however am getting invalid credentials error.

 

Any idea's how to pass my API Key as part of the URL when adding my Web data source to gateway?

 

Thanks,

 

Lee

v-shex-msft
Community Support
Community Support

HI @eamonnde,

 

Can you please share more detail information to help use clarify your scenario? (for e.g. datasource type, connection mode, data source credentials setting, screenshots, gateway logs)

 

Reference links:

How to Get Your Question Answered Quickly

Troubleshooting the On-premises data gateway

 

Regards,

Xiaoxin Sheng

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

Hi Xiaoxin,

 

The data is being directly imported from a SQL Server DB with a SQL query being used to import the data directly into Power BI.

 

The credentials give me permission to pull the data into Power BI without any issues and the refresh option in Power BI desktop works fine, the same credentials are used in Power BI online to access the data through the gateway, all gateway connections are online and good to go.

 

When i hit refresh on report 1 in Power BI online, all content refreshes without any issues, when i do the same for report 2 I get the following response.

 

image.png

 

Thanks

Eamonn

ttankka
Frequent Visitor

Eamon,

 

I am currently having the same issue that you describe.  Were you able to resolve this?  If so, could you please share.

 

Thank you,

 

Tim

eamonnde
Frequent Visitor

Hi Tim,

 

Our issue seemed to revolve around the certificate not have the server name, we added it and it worked for us.

 

Apologies for the delay in response.

Eamonn

View solution in original post

That's not a solution

Anonymous
Not applicable

How and where can I add the certificate? I'm having the same issue, the report worked perfectly for months and suddenly I have this problem, I have no idea if something happened with the domain accounts or what. Please show us how you solved this issue.

I am having the same issue but I am not able to follow your answer. Can you please elaborate little bit how/where I need to add the certificate? 

Thanks.

Hi @eamonnde,

 

I'd like to suggest you double check dataset of reports, it seems like your credentials are dropped.

 

In addition, which gateway you used? If you mean personal gateway, have you try to use on-premise version and try again?

 

Regards,

Xiaoxin Sheng

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

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!