Power BI doesn't store data like that. In your case, I would set up a Flow to name and store your daily csv files (choose a name that incorporates the date so you can use it downstream), and have Power BI combine all the CSVs. If the csv is emailed to you, you can trigger the flow based on that. If manual, you could rename it (with date info) and store in a SharePoint or OneDrive location for easy refresh from Power BI.
Did I answer your question? Please mark my post as a solution! Kudos are also appreciated!
That is how I do It but it is no reliable a practical a the data is about 32,000 records daily and if you miss to do the store and renaming process I loose the entire day. Data is refreshed daily at 12:00.
It looks I will help for the SQL guys to to develop a query.