Connect to FTP server

[mkurup12]

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 creating a batch file that copies and pastes all the files from the FTP folder into another location but this doesn't continue to work when I am signed off of the computer.

Thank you!!

[danextian]

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.

[v-easonf-msft · Accepted solution]

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

[amitchandak]

@mkurup12 , might not connect directly

refer

https://community.powerbi.com/t5/Power-Query/Connect-to-FTP-folder-with-txt-files/m-p/2503750

https://www.linkedin.com/pulse/how-connect-microsoft-power-bi-data-sftp-ftp-marcos-fattibello

https://community.powerbi.com/t5/Desktop/Connect-Power-BI-to-FTP/m-p/503802