Connect Shared Excel File from Google Drive to Power BI

[ErikOmni]

Hi!

So I've gone through A LOT of past forum threads to try to understand how to connect data in an shared Excel File sitting in a Google Drive but no solution, other than making the data public seem to do the trick.

So, is there any way to connect the data from a shared Excel File, sitting in on a Google Drive, without making the data public?

Thanks!

[v-yanjiang-msft]

Hi @ErikOmni ,

Is your problem solved? If so, would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirment will find the solution quickly and benefit here, thank you!

Best Regards,
Community Support Team _ kalyj

[v-tangjie-msft · Accepted solution]

Hi @ErikOmni ,

I'd like to suggest you take a look at following link about use power bi to get data from google drive files:

need help with Google docs data 

How to connect excel file shared through google drive | Power BI Exchange (pbiusergroup.com)

Connect Google Sheets to Power BI: An Easy Guide (hevodata.com)

Connecting Google Drive to Power BI: A Comprehensive Guide (hevodata.com)

Best Regards,

Neeko Tang

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

[amitchandak]

@ErikOmni , refer the google sheet part from this blog - https://community.powerbi.com/t5/Power-Platform-Integrations/Power-Apps-Power-BI-Better-together-Wri...