Forum Discussion
Unable to connect Power BI to SQL server db on the same computer
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,
I have tried in the last few minutes and everything worked,
I swear that I did nothing more than what I did before last weeks, there are also the screenshots ... bo ...
true that now I have a new version of Power BI, but the version of Excel is always the same...
I have always the error:
"Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server.
The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow
remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"and ONLY with this db and ONLY when I write a query, if I import the whole tables everything is ok
PLEASE HELP HELP HELP !!!!!!!!!!!!!!!!!!!
- I have same problem, please what should I do?
