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...
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.
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 ?