Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ikhwan_tokenomy
Frequent Visitor

Connecting to Google Sheet - Requiring Sign in

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

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

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 

1.png

View solution in original post

3 REPLIES 3
v-eqin-msft
Community Support
Community Support

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

Vijay_A_Verma
Super User
Super User

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 

1.png

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors