Forum Discussion
desktop reports vs service reports when refreshing csv files on onedrive
Hi Chris
That is confusing!
In my testing, if you have loaded a pbix from desktop using a one drive file then you have to use a gateway link to be able to refresh it. Thats the same in a My Workspace and an application workspace.
Howerver, if you create a report in the service using a file on your one drive. The service will maintain the refresh for you hourly.
Checking the PBIX query, its just using the local windows path to the file rather than any special One Drive connector.
Tim
Hi Chris
That is confusing!
In my testing, if you have loaded a pbix from desktop using a one drive file then you have to use a gateway link to be able to refresh it. Thats the same in a My Workspace and an application workspace.
Howerver, if you create a report in the service using a file on your one drive. The service will maintain the refresh for you hourly.
Checking the PBIX query, its just using the local windows path to the file rather than any special One Drive connector.
Tim
Greetings Tim,
Many thanks for that!
It seems that understanding csv data-refresh is proving awkward for a number of users - and it really is a case of "If I only knew then what I know now...".
...I would have designed all my reports using the BI Service, not the Desktop.
Ultimately the huge utility of hourly data refreshes via a csv source is so compelling that I will now switch to the Service & re-do the reports - I think its worth the trouble.
Thanks again, Chris