Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Google sheet connector in data gateway

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?

gateway
google sheet

4 Replies

  • PijushRoy's avatar
    PijushRoy
    Icon for Community Champion rankCommunity Champion
    4 years ago

    Hi Anonymous 

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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's avatar
        PijushRoy
        Icon for Community Champion rankCommunity Champion
        4 years ago

        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