Forum Discussion
SFTP/FTP files access
Hi, DeepDive
Based on my research, there are several ways that are offered.
1. You can use FTP commands or third-party tools to bring files down to local folder, then connect to the folder by using the Get Data ->Folder option in Power BI Desktop.
2. You can use Microsoft Flow to automate the extraction of your data from the FTP server to your OneDrive or SharePoint.
See the links below for more information:
https://community.powerbi.com/t5/Power-Query/connection-with-ftp/td-p/91792
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
https://www.cdata.com/kb/tech/ftp-odata-power-bi.rst
https://www.cdata.com/kb/tech/sftp-powerbi-dataflows.rst
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Well, I will try to resolve this problem right now, it seems to me that you need to have a look at this source on https://www.turboftp.com/turboftp/schedule-file-transfer.html and try that TurboFTP client. It looks and works quite good so I hope that you will find everything that you need in case you are looking for something that will schedule transfer and synchronization with the help of task scheduler.