Power BI Error from new SQL Server - certificate chain was issued by an authority the is not trusted

Hi 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