Need to link a private google sheet (internal data)

[Anonymous]

Hi,

I've been looking all over the net and I can't find out how to link a private google sheet to Power BI. There are options to publish the google sheet but because it's an internal data sheet I can't do that. Does anyone else know if there is any other ways to link it beside going through excel? I need it to update the data automaticly instead of me refreshing each day. 

Thank you in advance,

Liz

[amitchandak · Accepted solution]

@Anonymous 

Refer

https://community.powerbi.com/t5/Power-Query/Connecting-Power-BI-to-Private-Google-Sheet/m-p/199660

https://community.powerbi.com/t5/Power-Query/Connect-to-Google-Sheets/m-p/612193

Vote:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/6656584-connectivity-to-google-sheets

[Anonymous]

@amitchandak 

Thank you for much for responding. I've called our IT Team so they can look into this and fingers crossed we can use the Google Sheet ODBC Driver or if they can come up with another solution.

Once I heard from them I'll update you.

Thank you,

Liz

[v-lionel-msft]

Hi @Anonymous ,

Have you tried this method?

How to connect google sheet with power bi? 

Best regards,
Lionel Chen

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