Importing Teams dataverse tables into power BI - ErrorCode=-2146232060

[Anonymous]

Trying to import Teams environment dataverse tables into power BI, receiving the following 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I have owner permissions on environment tables and Power Platform admin role (& Fabric admin role)

Any help would be greatly appreciated. 

[Anonymous]

Hi @Anonymous ,

You can refer the following links to try to solve your problem:

The prerequisites of connecting to Dataverse:

Power Query Dataverse connector - Power Query | Microsoft Learn

Make sure input the correct URL:

Error message: Unable to connect (provider Named Pipes Provider, error: 40 – Could not open a connection to SQL Server)

When this error message occurs, the connector fails to connect to the TDS endpoint. This can occur when the URL used with the connector includes https:// and/or the ending /.

Remove the https:// and ending forward slash so that the URL is in the form orgname.crm.dynamics.com.

---

Fixed – Error – “Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server” – while trying to use Dataverse connector in Power BI – Nishant Rana's Weblog

Best Regards

[mwayte]

Hi Rena, Thanks for your reply!

I have tried the above solution, appending the port number to the end of the environment url but getting the following issue still. 

I used blank query as the dataverse connector does not let me change the envrionment url to append the port number. 

Any help would be greatly appreciated!

[Anonymous]

Hi @mwayte ，

Could you please check and confirm the following info?

1.  The URL address is correct

2. Has opened the port 5558, if no, you can refer the following links to get it

Configure a Windows Firewall for Database Engine Access - SQL Server | Microsoft Learn

How to Open Ports in Your Firewall: Easy Windows & Mac Guide (wikihow.com)

3. Update the code of Source as below if all above information are OK

= CommonDataService.Database("xx.crm.dynamics.com,5558")

Best Regards