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 connect to SQL Server from SQL Server Management Studio(SSMS), with no problems (with windows authentications).
Using PowerBI I have the following error, fig. 2:
"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)"
(with connections see fig. 1)
but the server is configured to allow remote connections, see fig. 3
help
15 Replies
so it works, see fig, I can see all the tables of the db. But if I use 'Advanced options' with a query, I have the error...
But I can't write any query, there is always the error writing a query...
perpor,
What error message do you get when you write a query in Power BI Desktop? In your scenario, please make sure the following things.
1. Ensure that you use the latest version of Power BI Desktop(2.50.4859.502).
2. Ensure that the query you write runs without issues in SQL Server Management Studio.
3. Specify machine name\instance name or IP\instance name as Server when connecting to SQL Server in Power BI Desktop.
Regards,
Lydia
How to Connect to remote sql server from power bi desktop to author visualizations? Is it necessery to open Tcp port to connect to sql server on aws EC2 instance. I have security concerns ... Needs urgent help
- I have same problem, trying to connect to remote sql Server.
