Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am using SQL Server Express 2022 version. When I try to connect my SQL Database with Power Query, it shows me this error.
Details: "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.)"
Can anyone please advise how to fix this error?
@Ibendlin
Thank you
Solved! Go to Solution.
Hi @aAmirkHan,
Thank you for reaching out to the Microsoft Fabric community Forum.
After reviewing the details regarding the issue of connecting the SQL Server Database with Power Query, please refer to the steps below to address this issue.
After making these changes, restart the SQL server and power query services to ensure the changes take effect.
Please go through the below documentation links for better understanding:
Power Query SQL Server connector - Power Query | Microsoft Learn
Connections and authentication in Power Query Online - Power Query | Microsoft Learn
If you have any further queries, please feel free to reach out to us we will guide you accordingly. If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @aAmirkHan,
Thank you for reaching out to the Microsoft Fabric community Forum.
After reviewing the details regarding the issue of connecting the SQL Server Database with Power Query, please refer to the steps below to address this issue.
After making these changes, restart the SQL server and power query services to ensure the changes take effect.
Please go through the below documentation links for better understanding:
Power Query SQL Server connector - Power Query | Microsoft Learn
Connections and authentication in Power Query Online - Power Query | Microsoft Learn
If you have any further queries, please feel free to reach out to us we will guide you accordingly. If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Thank you.
Hi @aAmirkHan,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
On-premises data gateway November 2024 release | Microsoft Power BI Blog | Microsoft Power BI
To troubleshoot this error when using Power BI Desktop, modify the value of the environment variable PBI_SQL_TRUSTED_SERVERS
to include the SQL Servers. The supported values are the same as outlined for gateway configuration (as described in step 4 above).
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!