Unable to set local data provider as non-refreshable

[Former Member]

I am trying to save an Excel file as a local data provider using BO4 Webi Rich Client so I can use it on LaunchPad to schedule a report. 

My local file contains target/plan data that is not available in the source system.  I want to combine this with actuals from the BO Unverse to create a report.   I have successfully created the query, but I think I need to uncheck "Refreshable" on the local data provider query before saving to the Enterprise server in order to make it available in the repository.

I want users to be able to refresh the Universe data, but have the Excel data remain static.  If I leave "Refreshable" checked, then when you refresh the report from the LaunchPad, I get "the file that is required to refresh the query cannot be found on the file system" b/c it is located on my local hard drive.

How can I uncheck "Refreshable" without losing my data?  If I do so currently, I have to click Run Queries which then returns no data in the resulting query.

If I can save the local data provider as non-Refreshable, will this allow me to refresh my report from the server?

Thanks in advance.

[former_member189638]

Did you try unchecking both the Refreshable and Editable checkbox and saving it to the enterprise??

Does it still return No Data message when refreshed?