Hi,
Possibly a trivial query but one that isn't 100% clear - I'm looking to archive and remove a lot of historical daily reports we have on our server which are all identical .csv files, so I've imported the folder they're all in as a folder, done a little bit of manipulation within Power Query and the .pbix file is set up as I want it. I then intend on deleting the source folder to free up space.
I know that if I leave the file as it is and don't try to refresh it at any point, the data will stay in the .pbix file (and I presume similarly in the service), but I may want to append on further reports when archiving at a later date. I assume that if I take the main query and uncheck include in report refresh, the data it was using no longer being there won't be a problem, that said, the "helper queries" created when setting up the import of the folder have that option greyed out - can anyone advise if it'd be safe to just uncheck include in refresh on the main query and then remove the source data? I guess I could test by renaming the folder for now but don't know if anyone's tried similar already
