Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi,
I am using the Desktop version. I am unable to connect to a Microsoft SQL Server. I do not get any error message. It just keeps spinning and spinning and never connects. Sometimes I get to the the second screen where it says to use windows credentials but then that just keeps loading. I am able to connect to this SQL sever with Tableau and Qlik but am having trouble with Power BI.
Any suggestions?
Solved! Go to Solution.
On your login screen for database engine click on 'Options'
Then click on "connection properties" tab and uncheck "Encrypt connection".
Hope this helps.
Hi @sstar118
Can you confirm that you have got the correct drivers installed to connect to SQL Server for Power BI?
I stand to be corrected but I do recall having to install SQL Server Management Studio.
https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms
Hi @GilbertQ
I let it connect for about 20 minutes and then got a message that it needed to be an encrypted connection, once I hit okay I was able to connect. Is there anyway to kick it off an an ecrypted connection so that it does not take so long to connect in the future.
Thanks!
thank you all. My issue has been resolved
On your login screen for database engine click on 'Options'
Then click on "connection properties" tab and uncheck "Encrypt connection".
Hope this helps.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
100 | |
65 | |
44 | |
36 | |
36 |