Forum Discussion
Importing Teams dataverse tables into power BI - ErrorCode=-2146232060
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.
3 Replies
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:
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.
Best Regards
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!
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
