Forum Discussion
Helper IIrefresh without on-premise gateway
Hi!
I have a report with google sheets as a data source. How can I refresh it without installing a gateway? As if I install gateway on my computer, the report won't refresh when the computer is shut.
Appreciate you help!
Maria
Ok, I found out the solution. It turned out to be super easy.
Thanks to this video.
The link should be to an excel or csv file (as shown in the video). What I did is I copied link to html.
I hope that it will help someone like me)))
6 Replies
Maria_MariaOk, I found out the solution. It turned out to be super easy.
Thanks to this video.
The link should be to an excel or csv file (as shown in the video). What I did is I copied link to html.
I hope that it will help someone like me)))
PaulDBrownCommunity Champion
You need to have the source files in a cloud service such as OneDrive and reference the source to the online url in Desktop. Once published, the report will update directly
This video explains how with Excel files
- Maria_Maria
PaulDBrown Thanks for the video! Can I do that with google drive instead?
Google sheets are not locally stored..
- PaulDBrown
It should also work on Google Drive