Connecting to Google Sheet - Requiring Sign in

[ikhwan_tokenomy]

Dear PowerBI Community,


is there a way to connect to google sheet that require sign in?
Web connection seems to only able to connect anonymously, is there a way to access published google sheet that require sign in?

Thanks

[v-eqin-msft]

Hi @ikhwan_tokenomy ,

Any updates? Could you tell me if you could connect to Google Sheet successfully? Or if there are any errors?

Best Regards,
Eyelyn Qin

[ikhwan_tokenomy]

sorry for late reply.. the issue is fixed after switching the connector from Web to using google sheets Beta

[Vijay_A_Verma · Accepted solution]

There is a Google Sheet connector (still in beta) which you can use in Power BI Desktop (not in Excel). This forces you to sign-in. 

Documention @ https://docs.microsoft.com/en-us/power-query/connectors/googlesheets