Although depending on how you pulled information into Excel, that may be the provider listed and we need to match that as I’ve described in other blogs. NET Provider or SQL Server Native Client if possible.
This is a really old provide and we should move to the. They were using the Microsoft OLE DB Provider for SQL Server as the provider. We would get a failure in a different application as well, such as Management Studio. While we are using Power BI, this is a great example of just a regular connectivity issue.
The client in this case will be the Data Management Gateway. When we get an SSL error, we are talking about Certificates and trying to encrypt traffic between the client and the Data Source. I was approached with a case where the customer was trying to create a Data Source within the Power BI Admin Center and received the following error when trying to test the connection and having Encrypt Connection selected.įailed to test connection.
0 kommentar(er)
