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?
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.
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.
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?
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
Helpful resources
Announcements
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
