This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 62%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESY%3C/text%3E%3C/svg%3E)
Getting below error while connecting Sql to Power Bi
We encountered an error while trying to connect. Details: "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)"
Verify that the instance name is correct
As the message says.
Can you connect to the same SQL Server name with other tools like SSMS or MS Excel?
Is the SQL Server service running at all?
Yes, on other tools its working fine only facing issue while connecting to power BI
The error message means that Power BI was not able to find the SQL Server instance you specified. There can be a number of reasons for this, including firewalls.
Is this database a database in Azure? If so, what more exactly? Or is it a database on-prem?
Hi @Sachin Yadav
A network-related or instance-specific error occurred while establishing a connection to SQL Server.
Regarding this error, this article provides some steps to help you troubleshoot, which are provided in order of the issues from simple to complex.
Best regards,
Cosmog
If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".