Using google sheet as a data source

[EhrenJ]

I have a source that is a google spreadsheet, which is set to have restricted access "Only people with access can open with the link" and not Anyone with the link. 

I've already tried connecting a google sheet in which was not published to web but rather Anyone with the link. (Not sure what the difference is to be honest), and I was successfully able to connect it to Power BI desktop by using the web data connector.

Now my issue is that I need to have that google sheet set to restricted access only. My question is, is there another way to connect a restricted google sheet (in which I have access to, furthermore, is the owner of the sheet) to Power BI?

[AlexisOlson · Accepted solution]

I just tried this with the Google Sheets connector and it worked fine. For authorization, it opened up a browser window for me to sign into my Google account.

The query code ended up looking like this:

let
    Source = GoogleSheets.Contents("https://docs.google.com/spreadsheets/d/[GUID REDACTED]/edit#gid=0"),
    Sheet1_Table = Source{[name="Sheet1",ItemKind="Table"]}[Data]
in
    Sheet1_Table

[EhrenJ]

Ah it has a dedicated connector, I did not know this, thank you!