Connect From Google Sheet to PowerQuery (without public link or sharing with everyone)

[Anonymous]

Hi,

Is there a way to share google sheet with specific memeber(email) and use this link for connection to power query?

(I cant make it sharebale to everyone who have the link)

Please help me to find the solution 🙂  - I thought that there is a place in power bi to ger to this link with my google account credentials but didn't find something like this

Thanks!

[v-alq-msft]

Hi, @Anonymous 

You may try to connect to Google sheets using R or custom connector in Power BI Desktop. Both methods require authentication, which builds a secure channel between Google sheet and Power BI. For more details, please review the following blog.

https://itsalocke.com/blog/connect-to-google-sheets-in-power-bi-using-r/
https://www.thebiccountant.com/2017/09/24/custom-connector-import-google-sheets-oauth2-powerbi/

Best Regards

Allan

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

[lbendlin]

This one still works for me.

https://community.powerbi.com/t5/Power-Query/How-to-connect-google-sheet-to-Power-BI/td-p/14587

it requires the data to be public though, not sure if that is ok with your dataset.