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 r...
gateway
google sheet
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