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.
Hell,
When you said :
"You can manually refresh the dataset by using Refresh now or you can set up a refresh schedule by using Schedule Refresh. Power BI automatically connects to the workbook on OneDrive, or SharePoint Online, about every hour to check for updates. If the workbook has changed, Power BI will refresh the dataset and reports in the Power BI service."
you can set up a refresh schedule by using Schedule Refresh , this is exatly what I want to do, all my data are imported with powerbi web connector, and all targets (urls) come from google sheets with this type of url : https://docs.google.com/spreadsheets/d/e/2.......
So how can I set up schedule refresh without gateway ? In powerbi desktop ? In https://app.powerbi.com/ ? both ?
Thanks for your help
Noliverte
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