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.
Super UserHi MarkSanchez,
idk about your Power Bi version but you can Use Power query editor instead of this option (Guaranteed to Work):
First, connect normally (you'll get the error)
Click Transform Data to open Power Query Editor
In the Applied Steps pane, click on Source
In the Formula Bar above, you'll see something like:
= Sql.Database("your-server", "your-database")- Modify it to add the parameter:
= Sql.Database("your-server", "your-database", [TrustServerCertificate=true])- Press Enter and click Close & Apply
Note : If this method didn't work try the below method (Advanced Editor)
- In Power Query Editor, go to Home → Advanced Editor
- Find the line with Sql.Database
- Modify it to:
Source = Sql.Database("your-server", "your-database", [TrustServerCertificate=true])
This Method should Work (Method 2) regardless of your Power BI version
I have the same issue as the OP trying to connect to a SQL Server in Power BI. The solution for using Power Query Editor appears would only work if you have already connected to SQL Server. I cannot get a connection, so Query options like "Advanced Editor" are grayed out. And I do not see anything for "Applied Steps". Is there any other way to tell Power BI to connect with TrustServerCertificate=true? (and why wouldn't Power BI just use the same connection dialog as SSMS?)
I am using Power BI Desktop v 2.155.756 (June 2026).
Thank you!