cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

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

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!

2 REPLIES 2
Highlighted
Community Champion
Community Champion

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

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.

Highlighted
Community Support
Community Support

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

Hi, @Martins1188 

 

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.

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.