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
