Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to 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
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
sorry for late reply.. the issue is fixed after switching the connector from Web to using google sheets Beta
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