Forum Discussion
Solved
Certificate Chain Not Trusted Error Effecting PowerBI Only
Hi, In a SQL query that I have run several times before I am not receiving the following error: Message=A connection was successfully established with the server, but then an error occurred ...
This ended up being a fairly easy solution, in order to work around this issue I ended up just having to switch the connection type from MSFT account to Windows for any who encounter this issue in the future.
An exception occurred: Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.) (Session ID: bc331829-2703-45b6-8774-5dcf513cbb99, Region: southafrica)
I still get this issue when i am trying to use dataflow on powerbi service using gateway connections, i have tried all methods, but its not working.