Forum Discussion
Power BI Error from new SQL Server - certificate chain was issued by an authority the is not trusted
Hi MarkSanchez,
So i digged the web for your issue and find some amazing stuff so could you please review these solutions & documents:
1-This is your issue (SSL Certificate Chain Not Trusted)
2-This also another solution For your Issue (certificate chain not trusted)
3-Import data from a database using native database query
4-SqlConnection.ConnectionString Property
5-Sql.Database
These Resources will explain better than me I hope this is helpful ☺️❤️
I recommend you the First and Second Solution 😅❤️if this post helps, then I would appreciate a thumbs up and mark it as the solution to help the other members find it more quickly.
Advocate IVMake sure your login in PowerBI matches how you log in via SSMS, especially if you log in with your Windows credentials or database credentials.
In PowerBI desktop, TransformData > Data source Settings > Choose the connection and "Edit Permissions". Under credentials, make sure it's using the right type of credentials. Connections are often defaulted to "Microsoft account" where you'd log in with your email and go through the OAuth pathway like you're logging in to your cloud services.
If it's set up correctly, sometimes just re-doing the credentials setup in PowerBI will help clear things out and get them working.
Thanks for your response. I confirmed that my login for both PBI and SSMS do match.
I am aware of the "Edit Permissions" option but that only comes into play once you have connected and reruned a data set. In my case, nothing is returned.
I can literally enter a SQL statement in PBI like: select * from Employees where active = 1
I get an error when trying it from the new Server, but it works from the old Server.