Forum Discussion

noliverte's avatar
noliverte
Helper III
6 years ago
Solved

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's avatar
    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.

noliverte's avatar
noliverte
Helper III
6 years ago

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

edhans's avatar
edhans
Community Champion
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.