Forum Discussion
Unable to connect Power BI to SQL server db on the same computer
I works a lot with Power Bi and Sql server, from many months, with the db on a server remote, no problems. I have created a Sql server db on my computer, where Power BI is installed, and I can conne...
perpor,
There are some proposals for you troubleshooting this issue.
1. Enable TCP/IP in SQL Server Configuration Manager(SSCM).
2. Configure a static port for your SQL instance in SSCM.
3. Restart SQL Server Service in SSCM.
4. Launch Power BI desktop with admin privileges, go to “File –> Options and Settings –> Options –> Data Load” to clear cache in Power BI Desktop, then connect to SQL Server by using "tcp:machinename,port" as Server, and write query to check if the connection is successful.
If you still get error, please post the screenshot about the connection in Power BI Desktop.
Regards,
Anonymous Thank you, works perfectly.