Forum Discussion
SQL > connection successful but error during login (certificate untrusted)
Hi,
Since this week I get an error when opening my data flow connected to an SQL data source.
The data source is available and the Gateway is update to the latest release
Error message
The data source setting are basic with Organizational privvacy level
Data source setting
Any idea what's the issue and how to solve?
I already tried to log out and in from my MS account.
2 Replies
Hi Moniek_NL
1.Try to switch the connection type from MSFT account to Windows.
You can refer to the following link.
Solved: Certificate Chain Not Trusted Error Effecting Powe... - Microsoft Power BI Community
2.Try to cleared the "Global permissions" on the power bi file dataset and then connect it again and add it to gateway.
And you can refer to the following link.
SSL Security Error with Data Source | Microsoft Power BI Blog | Microsoft Power BI
Solved: provider: SSL provider, error 0:The certificate ch... - Microsoft Power BI Community
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnkitKukreja
Super User
Hi Moniek_NL
This looks like the certificate on source side has expired. Please review this with your data source team and get the certificate renewed and it should work. Also to test this scenario you can try connecting the datasource to Dataflow or in Desktop and I would expect to see same errors.
