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
Useful Community Tools And Resources For Power BI And Fabric
There are a lot of really cool free, community-developed tools and resources out there for Power BI and Fabric – so many that it’s...
Power Platform – Data masking service updates
We are enhancing the Data masking service to allow administrators to view masked fields via the client and enable auditors to see who accessed...
Everything About Embedding Power BI into Dynamics 365
Are you still struggling with managing and analyzing large datasets—like 1000 records or more—within CRM systems? Then no more. We have encoun...
Vibe coding with Power Platform
Microsoft released one of the most exciting features of the year from a Power Platform perspective over the summer: the ability to build an ap...
Viva Insights: New Power BI report for Microsoft 365 Copilot agent metrics
Microsoft Viva Insights introduces a new Power BI report for Microsoft 365 Copilot declarative agents, providing leaders and admins with adopt...
Power BI Pro Trick: Sort Visuals by Fields NOT on the Chart!
Specific client requirements sometimes may force us to think out of the box and find not-so-obvious solutions The post Power BI Pro Trick: Sor...
Power Platform – August 2025 – Screenshot Summary
Community Call Highlights Quicklinks: Power Platform Community: Power Apps Power Automate Power BI Power Virtual Agents Power Pages M365 Pla...