Forum Discussion
noliverte
Helper III
Helper IIIrefresh data automatically google sheets
Hello, I use powerbi desktop, and I use web connector to import all my google sheets data. I published my report on the web (app.powerbi.com). How it's possible to refresh google sheets data...
noliverte - You need a gateway, but as you correctly surmised, you cannot install it on your personal computer as you shut it off. You need to install it on a PC or server that is up 24/7. If you turn the PC with the gateway off, your report will not refresh until you turn that PC on.
The On-Prem gateway is free. Just download, install, and configure. You'll then need to go to the Service under Settings, Manage Gateways and add that web source as a valid source the Gateway can use.
edhans
Community Champion
Community ChampionYou need an on-prem Gateway to set up the automatic refresh for web pages, which is how Google Sheets are imported. You can install the gateway from here.