2.87.684.0 64-bit (November 2020) breaks Smartsheet data connector

[_AJW_]

Since updating to Power BI Desktop 2.87.684.0 64-bit (November 2020), I can no longer refresh data from Smartsheet or establish a connection to Smartsheet.

On initial refresh or when trying to establish a connection to Smartsheet, I get the message: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel".

I also get a message that my Smartsheet credentials are not valid (organizational account using Microsoft SSO). From PBI desktop, when I try to sign-in to Smartsheet again or as a different user, I can get as far as allowing PBI to access Smartsheet data, but everything ultimately fails with the message "[Access denied] Power BI is unable to complete the login process".

I am 99% sure this is an issue with Power BI Desktop 2.87.684.0 64-bit (November 2020) as my colleagues are experiencing the same issue. Also datasets pulling on Smartsheet that are published to Power BI Workspaces appear to have no issue connecting to Smartsheet and refreshing their data as expected.

I have tried multiple installs / uninstalls of Power BI from the Microsoft Store as will as a direct download (x64 installer). I can reproduce the issue on multiple machines (professional & personal) and when connected with different networks (corporate, home, and public).

[KBGsyt]

I am having the same issues as @_AJW_ above. Any help here would be greatly appreciated.

[Anonymous]

Facing the same issue from last three days, checked SSL/TLS certificates which were updated recently. Any help on this is appreciated.

[Anonymous]

Facing the same issue PLUS I've been locked out of Power BI Desktop, I can still access the cloud/web version. This is a certificate issue I never faced before and here's what the error says: "The Underlying connection was closed: Could not establish trust relationship for SSL/TLS secure channel." Can this be solved please?

[v-lili6-msft]

hi  @_AJW_ 

This is a known issue:

https://powerbi.microsoft.com/en-us/support/

Power BI customers using the SU11(Nov 20) release of the Power BI desktop client and attempting to sign-in or publish to service may see the messages, “Sorry, we encountered an error while trying to sign you in. Details: An error occurred while sending the request” or “The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.” This is due to the enforcement of SSL certificates as part of the release . Customers are recommended to upgrade their SSL certificates or disable "Enable certificate revocation check" from File > Options and settings > Options > Security > “Enable certificate revocation check”.

Regards,

Lin