Forum Discussion

chiyow2828's avatar
chiyow2828
Frequent Visitor
3 years ago

Error in getting data from SQL Database

Hi. I am trying to connect to a server however I am getting error below.   Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi chiyow2828 ,


1. Check the server name used in the SQL Server database connector in Power BI Desktop.

2. Check the SQL server name mentioned in the certificate used to connect to the SQL server. You may need to consult with your SQL server admin if you're unsure how to check this.

3. Make sure the server names in steps 1 and 2 match. If they don't match, you'll need to use the same name mentioned in the certificate.

 

Best Regards,
Gao
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum