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.

komyji's avatar
komyji
Frequent Visitor
5 years ago

hi, i have created a workbook on google sheets and i want to link it to power bi. This works for me, but as soon as I publish the report to power bi online and share it with someone, the data is not automatically updated. Is it possible to publish the report online and at the same time to update the data from the google workbook? Thanks