search

TabularEditor / TabularEditor3

Bug reports, feature requests, discussion and documentation for Tabular Editor 3 (commercial version).
61 stars 7 forks source link

SSL Connection Error - Cannot Connect to Server #1242

Closed ry-guy5 closed 2 months ago

ry-guy5 commented 2 months ago

Description

Trying to connect to Power BI XMLA endpoint and receiving SSL connection error message. Seemed to start after Windows 11 upgrade.

Tabular Editor 3 Version

3.14.0

Screenshots

TE3 SSL Error

Steps to Reproduce

  1. Go to 'Open model from DB'
  2. Enter Power BI Service Workspace XMLA endpoint in Server field
  3. Click ok
  4. SSL error occurs

Expected behavior

I should be able to connect to the model in the PBI Service.

Crash Report

No response

Windows Version

Windows 11 (Version: 22H2)

otykier commented 2 months ago

We're not aware of any general issue after upgrading Windows 11.

I wonder if perhaps a firewall, VPN or Proxy could be interfering with your connection? Have you tried connecting to the XMLA endpoint using other tools, such as SQL Server Management Studio or DAX Studio? Also - if you're able to test this from more than one machine, that would also be helpful.

Also, if you could send us your Session ID (Help > About Tabular Editor) from one session where you've experienced this error, we may be able to locate the exact error details in our telemetry, for that particular session.

ry-guy5 commented 2 months ago

Interesting! TE2 (2.18.1) connects just fine, but DAX Studio (3.0.5) will not connect. Screenshot attached.

DAX Studio Connection Error

Are there any connection settings in TE3 I can adjust?

TE3 Session ID: 452c6c44-7641-4373-80c7-a3dfdb009b8f

otykier commented 2 months ago

You can try to change the proxy options under Tools > Preferences > Proxy settings (restart the application after making a change here), but that’s about it, I’m afraid. There may also be some XMLA connection string options you can explore, but I’m not aware of any that would impact SSL.

TE 2.18 uses an older version of the AMO/TOM client libraries that Tabular Editor uses to connect, so perhaps it’s a regression of this library (which is owned by Microsoft). Could you try to compare with an older version of TE3, for example 3.8.0? Not sure about DAX Studio, but they use ADOMD instead of TOM.

ry-guy5 commented 2 months ago

Tried TE3 3.8.0 and still experiencing SSL issue. Explored XMLA connection options...no luck.

TE3 3 8 Error

Will need to dig into proxy settings with IT. Will report findings.

ry-guy5 commented 2 months ago

FIX FOUND Resolution: TPM version was out of date and Group Policy was not updating correctly. Not a TE3 issue, rather an internal issue.

DBojsen commented 2 months ago

Hi @ry-guy5

Great that you resolved your issue, and thank you for pasting the solution her for visibility to others. I'll close the issue.

Best Regards

David - TE3 Support