cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Anonymous
Not applicable

googlesheet to powerbi desktop

I've  been attempting to connect Googlesheet to powerbi desktop but the data doesn't load as table. 

I've published the googlesheet I'm trying to load, took the url and change the end to /export?format=xlsx 

and tried using credentaisl, annoymous, etc but it seems like the page isn't going past the sign in page so it ends up loading the html data, not the actual table data from the googlesheet.

 

navigator.png

 

Does anyone know how to get around this? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Resident Rockstar
Resident Rockstar

Re: googlesheet to powerbi desktop

Hi @Anonymous ,

 

By my test, to connect to Google sheet, you can go to that specific spreadsheet, use Publish to the Web, change the selection from Web Page to Microsoft Excel

 

get the url.PNG

 

Then copy that generated URL, go to Power BI desktop, use Web data source and paste URL, enter credential use Basic Authentication to get data.

 

Capture.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Resident Rockstar
Resident Rockstar

Re: googlesheet to powerbi desktop

Hi @Anonymous ,

 

By my test, to connect to Google sheet, you can go to that specific spreadsheet, use Publish to the Web, change the selection from Web Page to Microsoft Excel

 

get the url.PNG

 

Then copy that generated URL, go to Power BI desktop, use Web data source and paste URL, enter credential use Basic Authentication to get data.

 

Capture.PNG

 

Best  Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Helper I
Helper I

Re: googlesheet to powerbi desktop

Hello 

 

I did the same steps but it did not work for me i got alwas null as in the first description

 

any help please?

 

Best Regards

Asma

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors