Unanswered

Unable to connect Power BI to Dataverse, error occurred during the pre-login handshake

(0) Share

Report

Posted on by Moxy

New to Dataverse so apologies if I've missed something obvious to others.

I stood up a new Environment with Dataverse enabled. A new table was created and I've loaded data to through a dataflow. I'm now attempting to build out a report through Power Bi as well as connecting directly to the tables through SSSM. While trying to connect to my environment I'm getting the following error:

"A connection was successfully established with the server, but then an error occurred during the pre-login handshake."

Categories:

Microsoft Dataverse with Power Apps

handshake_error_m...

I have the same question (0)

All responses (9)

Answers (1)

gulshankhurana 1,397 Moderator on at

Like (1)

Report

Hi @Moxy

Please could you ensure that the TDS endpoint is enabled in the settings of your environment and then use the Dataverse connector in the Power BI.
You may also find the following links helpful:

https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Dataverse

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query

If you like my response then please give it a thumbs up. If it helps resolve your query then please accept it as a solution.

Kind regards

Gulshan

Was this reply helpful? Yes No
Moxy 14 on at

Like (0)

Report

@gulshankhurana ,
Thanks for the reply. TDS Endpoint is enabled. I was also working off of both the links you provided but still receive the same error.

Was this reply helpful? Yes No
Mitanshu 1,650 Moderator on at

Like (0)

Report
I would suggest using ODATA feed from Dataverse to PowerBI as your Refresh will be noticeably faster

1 - PowerBI -> NewSource -> Blank Query
2 - Advanced Editor
3 - Type below (make changes to [ENV_URL] and SCHEMA_PLURAL_NAME as per your data)

let Source = OData.Feed("[ENV_URL]/api/data/v9.2", null, [Implementation="2.0"]), tblName = Source{[Name="SCHEMA_PLURAL_NAME",Signature="table"]}[Data] in tblName

If there is any issues in getting correct SCHEMA_PLURAL_NAME, then you can alternatively use below and then navigate to table of your requirement:

let Source = OData.Feed("[ENV_URL]/api/data/v9.2", null, [Implementation="2.0"]) in Source

[ENV_URL] is of format:
https://NNNNNN.crmN.dynamics.com
Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If this post or my previous reply was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

I am getting the same error, Can you please share the resolution ?

Was this reply helpful? Yes No
Moxy 14 on at

Like (0)

Report

I ended up using the Common Data Service (legacy) connector as outlined here, https://learn.microsoft.com/en-us/power-apps/maker/data-platform/data-platform-powerbi-connector?tabs=Legacy

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

If TDS Endpoint is enabled, ensure that both ports 1433 and 5558 are open to your environment. You can use a test-net connection command in powershell to test the ports. It’s toward the bottom of the docs so it’s easy to miss this requirement.

Was this reply helpful? Yes No
Verified answer

Moxy 14 on at

Like (0)

Report

For this situation the issue came down to not have the appropriate firewalls opened. Had to grant access to the IP addresses found here:

https://learn.microsoft.com/en-us/power-platform/admin/online-requirements#ip-addresses-and-urls
https://www.microsoft.com/en-us/download/details.aspx?id=56519

"sourceAddresses": [ "*" ], "sourceIpGroups": [], "destinationAddresses": ["PowerPlatformInfra"], "protocols": [ { "protocolType": "tcp", "port": 1433 }, { "protocolType": "tcp", "port": 5558 } ]

Was this reply helpful? Yes No
ivan_apps 2,187 Moderator on at

Like (0)

Report

👍 port 1433 and 5558 were a problem for me too

Was this reply helpful? Yes No
KennyChao150 2 on at

Like (0)

Report

.

Was this reply helpful? Yes No