Connecting to a Google Sheet

[sacabelo]

Hi, I have been trying to connect PowerBi to a google sheet using this resource https://www.youtube.com/watch?v=2hFCeduIP6k 

As intructed, I changed "edit?usp=sharing" for "export?format=xlsx". The google sheet has 9 tabs. After load it, I only see one "Document" tab and the preview shows columns "kind,name,children,text". Not sure why is not showing all tabs and data within each tab as a regular excel document.  Thanks!

[v-frfei-msft]

Hi @sacabelo ,

Based on my test using Power bi desktop version : 2.75.5649.582 64-bit (November 2019). I cannot reproduce your issue here. Could you please update your Power bi desktop to check agian? Or kindly sahre your sheet to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

[sacabelo]

I dowloaded the lastest verion of PowerBi. Still have the issue of can't get data from a Google sheet.

I can't load file since it is private information. But here what I get when I tried to get data from a google sheet...

This is what the google sheet looks like...Notide multiple tabs on the file...

Thank you for looking into 🙂

[sacabelo · Accepted solution]

The issue was on the permission on the Google Sheet. I had to allow view to everybody with the link, then, connected to PowerBi