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 worka...