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
Power BI and Dataverse | Creating Reusable Templates (PBIT)
Let’s say you need to create a Power BI report that pulls basic contact details — like First Name and Last Name — from the Dataverse Contact t...
Power Platform admin center – Deploy and manage unified sandbox environments
We are announcing the ability to deploy and manage unified sandbox environments in the Power Platform admin center. This feature will reach ge...
Microsoft Power Platform – Manage table list views with security roles
We are announcing the ability to manage table list views with security roles in Power Platform. This feature will reach general availability o...
Will Power BI Devs lose their jobs to AI?
Finding Reports And Semantic Models Easily With Power BI Copilot Search
By the time you read this it’s likely the new, standalone Power BI “Chat with your data” experience will be available in you...
Standalone Power BI Copilot experience is now available!
The new standalone Power BI Copilot experience has been released and now available to use. In order to start using this new experience the new...
Conversion Funnel Chart in Power BI
How to Highlight Specific Segments in Power BI Line Charts
Ever wanted to highlight just one part of a line chart in PowerBI? Maybe to emphasize a trend, a peak, or a dip? Well, now you can with the ne...
🚀 Introduction to Power BI: How Microsoft’s Hidden Gem Can Transform Your Business in 2025
Want to turn messy spreadsheets into stunning dashboards that actually drive decisions? You’re in the right place.📊 What is Power BI?Power BI...