Refreshing data on published report

[qmestu]

Hi,

I have a report that i have developed that gets its data from multiple sources, either Excel files or Web services. What do i need to change on the report that i developed on the desktop app so that these sources can be refreshed when the report is published? I would like to try to refresh all of the data on the published report because refreshing the data on the desktop app is very slow.

Thank you.

[djurecicK2 · Accepted solution]

Hi @qmestu ,

 If you are using Sharepoint/OneDrive, you can store the excel files there, then get the URL of the excel file and use as a web data source inside your report. Here is additional information:

https://www.biinsight.com/quick-tips-connecting-to-excel-files-stored-in-sharepoint-online-from-powe...