Forum Discussion
Solved
Connect to FTP server
Hi, How do I get power bi to pull data from an FTP folder? Is there a way to refresh the data as well? (Refreshing through power bi scheduled refresh is not working with this). I also tried creatin...
Hi, mkurup12
As a workaround, you can use the CData ODBC Driver for FTP (Third-Party Platform ) to visualize FTP data in Power BI Desktop and then uploading to the Power BI service.
See the links below for more details on how to connect to FTP as an ODBC data source.
Author and Share Power BI Reports on Real-Time FTP Data
Best Regards,
Community Support Team _ Eason
If you have an access to a Sharepoint folder and Power Automate, you can automatically move the FTP files to a SharePoint folder as they arrive and use SharePoint connection instead. There is already an existing template (which you might need to modify) in Power Automate that can do this.