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.
Hi noliverte ,
If your report dataset doesn't contain any on premise data source, that is to say the dataset only has the cloud data source Google sheet, then it needn't to use the gateway.
You can manually refresh the dataset by using Refresh now . 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.
If your dataset contains not only the cloud data source but also the on premise data source, then it needs to use the gateway, and then you can configure schedule refresh. See more : On-premises data gateway , Add a data source , Configure scheduled refresh .
Note that you also need to select Allow user's cloud data sources to refresh through this gateway cluster option Under Gateway Cluster Settings. See: Merge or append on-premises and cloud data sources.
In addition, the data gateway is free, and recommend you install on premise data gateway if a gateway is necessary. See more: Install an on-premises data gateway.
You shouldn't install a gateway on a computer, like a laptop, that might be turned off, asleep, or disconnected from the internet. The gateway can't run under any of those circumstances.
Because the gateway runs on the computer that you install it on, be sure to install it on a computer that's always turned on. For better performance and reliability, we recommend that the computer is on a wired network rather than a wireless one.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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