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

Highlighted
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

Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Top Solution Authors
Top Kudoed Authors