Google Sheets have multiple tabs but only one tab shows when connecting to PowerBI Desktop

[NHI]

Hi everyone,

When I connected my Google Sheet (4 tabs) into PowerBI desktop, I could only see data from Tab 1 integrated into my PowerBI. I could not locate the rest of the tabs.

Any ideas how to fix this issue? 

Cheers.

[v-eqin-msft · Accepted solution]

Hi @NHI ,

It may caused by Permissions. You need to allow view to everyone with the link, then, connected to Power BI.

Refer to:

Part 3: Connecting Power BI to Google Sheets - BizOne

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.