Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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 co...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

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's avatar
mwayte
Frequent Visitor
3 years ago

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!