SFTP/FTP files access

[DeepDive]

Hello all,

Is there any direct way, that I could connect my PBI to access files placed in SFTP/FTP. Also I want to enable scheduled refresh.

ps : files will be updated on daily basis in SFTP folder.

Any reference link/tutorial , pls share. thanks.

[v-angzheng-msft · Accepted solution]

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.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=3313bc81-...

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.