Google sheet connector in data gateway

[SJAV]

Hi!

I am using the google sheet beta connector in Power BI desktop and it's working great. However, I can't seem to add it as a data source to my On-premises data gateway, so I can't schedule a refresh. Does anybody know if there's a way around this?

[SJAV · Accepted solution]

Hey! It turned out I don't need to add it to the gateway. I found the link below and could just set up the gateway for the other sources and fill in my google sheet credentials in the Data source credentials submenu.

https://community.powerbi.com/t5/Service/Cannot-add-Google-Sheet-to-a-gateway-automatic-refresh/m-p/...

[PijushRoy]

Hi @SJAV 

You can setup Google Drive
Please look into 3 steps of this video, if works for you https://youtu.be/rEwWvDRyoVc

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[SJAV]

Hi! Thanks for your reply! Doesn't appear like any of them work since I need to be able to store my authentication credentials somewhere, I am not allowed to open it up to anonymous verification. The videos use web connector mostly, have you worked with the google sheets beta connector?

[PijushRoy]

If you see the video 3rd step, then you can use Google Drive as Computer or Server local drive.
If it is not ok, I will look into the other process and let you know.

If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos