Ftp folder to Power BI , best solutions?

Hi i have an ftp folder where a csv is uploaded daily.

I would like to aggregate the data, but as Ftp in PowerBI only works with specific files, it is not good.

I have looked a the ODBC workaround but can not make it work.

Is there any way i can recode in M the FTP - file only connection to include all files in the hole folder?