Error while connecting to Dataverse from Power BI

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.