Solving "Unable to connect" error of Dataverse connector in Power BI
When utilizing the default Dataverse Connector in Power BI, users may experience occasional malfunctions. As a result, some may switch to the "legacy" connector, which is not a long-term solution. This tip aims to address a common issue faced by numerous users when employing the default connector. The specific problem is as follows:
The inconsistency of this error is particularly troublesome, as it may appear or disappear intermittently, even with identical PBIX files. Following a thorough investigation, the issue was traced not to the connector, but to the network settings of the computer's connected network, irrespective of VPN usage. In other words, the error might not surface when using a customer VPN at home, but may reappear without VPN or when in the office. The root cause stems from Power BI Desktop's attempt to connect to the TDS Endpoint via ports 1433 or 5558. (see link to documentation).
So the solution is to check the connection to these ports via Powershell. This can be done with the following command:
In the screenshot provided, the initial connection attempt was unsuccessful. However, after changing to a different Wi-Fi network and disabling the VPN, the application successfully connected to the ports, enabling the use of the default connector as intended:
So all in all, a port issue, but one that has caused headaches for many people.
Published on:
Learn moreRelated posts
Microsoft 365 & Power Platform Call (Microsoft Speakers) – June 23rd, 2026 – Screenshot Summary
Call Highlights SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...
Business Central 2026 release wave 1 (BC28.2): Power BI Report Deployments (Centralized Management of Power BI Apps)
Hi, Readers.Dynamics 365 Business Central 2026 wave 1 (BC28.2) is generally available. More details: Cumulative Update Summary for Micros...
Protect once, enforce everywhere: Protection policies for Power BI (Generally Available)
How to use sensitivity labels and Protection Policies to secure your Power BI estate — and why it matters more than ever in the age of AI.&nbs...
New Book: “Extreme DAX” 2nd Edition
“Extreme DAX” by Michiel Rozema, Madzy Stikkelorum and Henk Vlootman Continuing my series of not-reviews of the latest Power BI-re...
Fabric App | Rayfin CLI | Create a Power BI Report
In my previous article : Build your first Fabric App using Rayfin CLI we learned how to create a Fabric App using Rayfin CLI After completing ...
Power Platform June 2026 Updates
Microsoft Entra ID single sign-on for the Starburst connector in Power BI (Preview)
When enabling Microsoft Entra ID single sign-on (SSo) for Starburst (Preview) report viewers querying semantic models in DirectQuery mode auth...
Microsoft 365 & Power Platform Community Call – June 18th, 2026 – Screenshot Summary
Call Highlights SharePoint Quicklinks: Primary PnP Website: https://aka.ms/m365pnp Documentation & Guidance SharePoint Dev Videos Issues...