refresh 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...

Need Help

Show and Tell

edhans
6 years ago
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.