Googlesheets Connection Issue

[HLP_PLZ]

When i try to connect to google sheets through power bi Desktop I get the below error: 

DataSource.Error The request was aborted: Could not create SSL/TLS secure channel

[v-rzhou-msft]

Hi  @HLP_PLZ ，

Firstly, please make sure your google account has access to your data source.

The Google Sheets connector supports connecting through an organizational (Google) account.

Here are some limitations and considerations when using the Google Sheets connector.

Shared drive support

This connector does support connecting to shared drives.

Multiple connections

This connector uses a different ResourcePath for every Google Sheet URL. You'll need to authenticate to every new resource path and URL, but you might not need to sign into Google multiple times if the previous sessions remain active.

Understanding URL parsing

The connector first checks for the signature of the URL, ensuring it starts with https://docs.google.com/spreadsheets/d/. The connector then parses the Google Spreadsheet ID from the URL to include in the Google Sheets API call. The rest of the URL isn't used. Each Google Sheet connection is tied to the submitted URL, which will act as the ResourcePath.

For reference: Google Sheets

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[HLP_PLZ]

Hello and thank you for replying, 

Unfortunately that's not the case, all the you have mentioned was done properly, and the case is more about creating a secure path for the connection and i cant figure from where