Data Storage - advice on best solution

[KG1]

Hi

We currently have csv / excel files stored in sharepoint

The files are scheduled from Oracle into a shared mailbox and a Powerautomate flow picks up the attachment and stores in on the Sharepoint.

Some files are being updated 3 times a day.

I am using the combine files process to upload the full dataset but now due the large amount of data it's becoming impossible to transform the data and is taking an age load.

All the files are in the same format each time

What is the best option for data storage and connecting Powerbi to it?

I have been looking at azure blob / data lakes / warehouses / sql but I dont know which one would be best

Thank you in advance

[lbendlin]

CSV files with names that include a datetime value.  Datasets with incremental refresh based on these values.

Incremental Refresh with Slow-Changing Source Data - Microsoft Power BI Community