Forum Discussion
Pre-Login Handshake Error with Dataverse as data source
Hi all, when I want to create a new Dataverse data source in PBI desktop, I get the following error (see screenshot below) DataSource.Error: Microsoft SQL: A connection was successfully established...
We had the same error (in PBI Desktop, Excel and SSMS) which was hard to pinpoint, since occasionally at least listing tables from a dataverse environment did work. Finally it turned out that the firewall (ZScaler) did block certain SSL-encrypted network traffic due to a false packet inspection security alerts. Solution was to generally disable deep packet inspection for the traffic on ports 1433 & 5558 to the hostnames/IPs for the according dataverse environment.