Forum Discussion
Certifiticate problem w enterprise gateway import mode, when direct mode works ok
We are using on-premise SQL server on a virtual machine and connecting using the enterprise gateway. The PowerBI online dataset and reports are built using PBI Desktop. For testing purposes I've used a single table and a single value column for a visual.
After setting a scheduled refresh for the dataset we receive the following error (I havent been able to change the system language to English, sorry for some Finnish on the table):
| Pohjana oleva virhesanoma: | The server name provided doesn't match the server name on the SQL Server SSL certificate. Please see https://go.microsoft.com/fwlink/?LinkId=394782. (Source at bilotreport1;bilotdw.) |
| DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
| Pohjana oleva virhekoodi: | -2147467259 |
| Microsoft.Data.Mashup.CredentialError.Reason: | PrincipleNameMismatch |
| Microsoft.Data.Mashup.CredentialError.DataSourceKind: | SQL |
| Microsoft.Data.Mashup.CredentialError.DataSourcePath: | ... |
| Klusterin URI: | WABI-NORTH-EUROPE-redirect.analysis.windows.net |
| Toiminnon tunnus: | ... |
| Pyynnön tunnus: | ... |
| Aika: | 2016-03-24 10:21:44Z |
The odd thing is that with the very same setup direct query mode works fine without any certificate issues!
I found the link within the refresh history on the gateway to be helpful. https://msdn.microsoft.com/en-us/library/ex6y04yf%28V=VS.110%29.aspx?f=255&MSPPError=-2147217396
In short, I was using the server shortname but the cert had the FQDN. So i used the FQDN in the connection so that the connection string matches the cert. Was a very simple fix.
10 Replies
I found the link within the refresh history on the gateway to be helpful. https://msdn.microsoft.com/en-us/library/ex6y04yf%28V=VS.110%29.aspx?f=255&MSPPError=-2147217396
In short, I was using the server shortname but the cert had the FQDN. So i used the FQDN in the connection so that the connection string matches the cert. Was a very simple fix.
I'm having the same issue, exept I am using the FQDN in the connection string. But I still get the same error message. No reply from PowerBI support yet despite rasing a ticket.
The above link does not give me information on how to determine the FDQN, or at least I am missing or not able to understand how to get it. Is there somewhere on the SQL server that can identify this?
You can obtain your FQDN by typing the following into PowerShell:
[System.Net.Dns]::GetHostByName(($env:computerName))
If you run that from the SQL server host, it will give the FQDN.
Could you send your Gateway Logs to [email protected] , logs can be found at: C:\Users\PBIEgwService\AppData\Local\Microsoft\Power BI Enterprise Gateway\EnterpriseGateway*.log
I have the same issue. Direct Query works. We tried FQDN and IP address to solve the issue.
Neither of these would connect to the server.
Were you able to get it fixed using this: https://msdn.microsoft.com/en-us/library/ex6y04yf%28V=VS.110%29.aspx?f=255&MSPPError=-2147217396 ?
