Error while connecting to Dataverse from Power BI

[Fern_21]

Hi all!

In Power BI, I need to connect in Direct Query mode to tables stored in Dataverse, but I receive the following error:

DataSource.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)

Details:

• DataSourceKind = CommonDataService

• DataSourcePath = org5f82309d.crm4.dynamics.com

• Message = 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)

• ErrorCode = -2146232060

• Number = 53

• Class = 20

• State = 0

• ConnectionId = 00000000-0000-0000-0000-000000000000

How can I fix this? Thanks

[v-pnaroju-msft]

Hi Fern_21,

We are following up to see if what we shared solved your issue. If you need more support, please reach out to the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Hi Fern_21,

We would like to follow up and see whether the details we shared have resolved your problem. If you need any more assistance, please feel free to connect with the Microsoft Fabric community.

Thank you.

[v-pnaroju-msft]

Thankyou, @MasonMA, for your response.

Hi Fern_21,

We appreciate your inquiry submitted via the Microsoft Fabric Community Forum.

Based on my understanding, the error indicates that Power BI Desktop is unable to reach the Dataverse TDS endpoint. This is typically caused by a network connectivity issue, commonly because the TCP ports 1433 or 5558 used by Dataverse are blocked by a firewall, proxy, or VPN, or because the TDS endpoint is not enabled in your environment.

Please follow the steps below, which may help resolve the issue:

1. Verify the server URL format. Use only the domain name, for example: org5f82309d.crm4.dynamics.com. Do not include https:// or a trailing slash.
2. Check network connectivity from your machine by running the following commands in Powershell.
   i)  Test-NetConnection -ComputerName org5f82309d.crm4.dynamics.com -Port 1433
   ii) Test-NetConnection -ComputerName org5f82309d.crm4.dynamics.com -Port 5558
   If both commands fail, request your network team to allow outbound TCP traffic on port 1433 or 5558.
3. Ensure the TDS endpoint is enabled. In the Power Platform Admin Center, select Environments, then Settings, and enable the TDS endpoint under Features.
4. Clear cached credentials in Power BI and update Power BI Desktop to the latest version.
5. If possible, try connecting from a different network to rule out VPN or firewall restrictions.

For further reference, please consult the links provided below:
Power Query Dataverse connector - Power Query | Microsoft Learn
Use SQL to query data (Microsoft Dataverse) - Power Apps | Microsoft Learn
Create a Power BI report using the Microsoft Dataverse connector - Power Apps | Microsoft Learn
Control access of the TDS endpoint - Power Platform | Microsoft Learn

We hope this information helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.

[MasonMA]

Having same issue lately for me as well when i was trying to connect to Dataverse. It turns out the Port 1433 was not open. Please refer to this post below. 

https://community.fabric.microsoft.com/t5/Desktop/DATAVERSE/m-p/4625690