Forum Discussion

Helper V

8 years ago

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...

Need Help

Anonymous

Not applicable

8 years ago

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,