Strategy to keep/store the data in Excel files received daily
I am at my wit's end, as my own Google searches have brought me no closer to a solution.
Current state: I daily receive an Excel file with the same name (a dump from our asset management system), with +- 80k records which I overwrite on OneDrive. This file is read by PBI desktop to report on.
Question: My management now needs historical information (I should have known this would happen). What is the simplest/best strategy to keep all these files/data? I might be overcomplicating it for myself, but where/how will I store all this data for PBI?
PS. A real database like SQL is not an option as I do not have the skills.