We have relatively complex dataset models with multiple tables and joins which feed in comprehensive workbooks.
We have a use case which is key for our customers which is that we would like at the end of a reporting cycle freeze these datasets or run the dataset through a dataflow to a data storage so that the workbook can continue being used on a frozen set of data. This provides strong benefits for customers who must be able to go back to the data used for reports to justify and explain in case of inspections.
We have tried this using a dataflow moving our multi table dataset to a file storage (one flat table) and were not able to then make the workbook work with the file storage. Is this a functionality which is supported by OAS/OAC?
