cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
bhaskariksl Visitor
Visitor

On-premises gateway - data source refresh Invalid connection credentials

I have installed On-premises gateway on server machine and mode of the gateway is On-premises data gateway
I have create 3 data sources in manage gateway screen in power bi online,all three data sources shows 'connection sucessful'
but the issue comes only 1 data sources other 2 datasource is wroking,
when I try to schedule a refresh on the deployed dataset it is returning the error below:
i have check power bi desktop report Credential and power bi online data sources Credential is same .what is the issues?

 

Details Type Start End Status Message

Hide Scheduled 2017-6-9 12:31:09 2017-6-9 12:40:13 Failed Invalid connection credentials.
Underlying error code: -2147467259
Underlying error message: The server name provided doesn't match the server name on the SQL Server SSL certificate. Source at win-xxxxxxx;IKSlccccc.)
DM_ErrorDetailNameCode_UnderlyingHResult: -2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind: SQL
Microsoft.Data.Mashup.CredentialError.DataSourcePath: WIN-xxxxxx;IKSlccccc
Microsoft.Data.Mashup.CredentialError.Reason: PrincipleNameMismatch
Microsoft.Data.Mashup.MashupSecurityException.DataSources: [{"kind":"SQL","path":"WIN-xxxxxx;IKSlccccc"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason: PrincipleNameMismatch
Cluster URI: WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net
Activity ID: e1543ef2-c77b-4db2-992b-7546a3212cec
Request ID: 09785140-e462-49e4-980e-5e180ceebd58
Time: 2017-06-09 07:10:13Z

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: On-premises gateway - data source refresh Invalid connection credentials

@bhaskariksl Check out this thread, it will most likely solve your issue.


Near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

5 REPLIES 5
Super User
Super User

Re: On-premises gateway - data source refresh Invalid connection credentials

@bhaskariksl Check out this thread, it will most likely solve your issue.


Near SE WI? Join our PUG Milwaukee Brew City PUG

View solution in original post

aizazahmed New Member
New Member

Re: On-premises gateway - data source refresh Invalid connection credentials

Hi buddy,

 

This issue appears when Power BI app try to connect to SQL server. where as SQL server needs authentication for this. 

Power BI installer creates a certificate to authenticate with SQL server and sometimes this certificate is not added in sql network configuration.

 

Add certificate manually at following location:

SQL Server Configuration Manager > SQL Server Network Configuration > Right Click Protocols for (Instance name) > Properties > Certificate

wvanpeel Regular Visitor
Regular Visitor

Re: On-premises gateway - data source refresh Invalid connection credentials

Hi, I'm having same issue, all worked fine until some days ago.   Direct query sources work still fine, only import gives this error.

In the solution, what do you mean with "PowerBI installer " ?

 

 

 

 

cafeolai Frequent Visitor
Frequent Visitor

Re: On-premises gateway - data source refresh Invalid connection credentials

Thank you , I had the same problem and following your instructions fixed it Smiley Happy   I had to make sure the FQDN name of the certificate match when creating a new connection in PBI Desktop.

Re: On-premises gateway - data source refresh Invalid connection credentials

Hi Ahmed,

 

I'm getting the same error.

I'm new to Power BI, can you please add some screenshots, how to resolve the issue.

 

It will be helpfull for me.

 

Thanks in Advance.

 

Regards,

Pavan Vanguri.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 119 members 1,553 guests
Please welcome our newest community members: