Forum Discussion
refresh data automatically google sheets
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.
You 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.
Thank you for all your responses.
I use Powerbi on my desktop and I switch off my computer sometimes several days... but I want that my report (on https://app.powerbi.com/) refresh data everyday... My company has this version of Powerbi (Power BI Pro for faculty - Power BI Pro)
Question 1 : Can I download on premise gateway with this version of Powerbi without paying extra money ?
Question 2 : Are all my data will be refreshed ? even if my computer is switched off ?
A response would be greatly appreciated
Noliverte
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.