How to connect to a FTP using Power BI

[Anonymous]

Hi,

I'm trying to connect to an internal FTP folder using Power BI to access a couple of csv files and do reporting on top of that. These csvs are refreshed on a daily basis so I'd be needing to schedule the refresh based on when it updates in the FTP folder.

I do have access to the hostname, service account and password to the FTP, however, not sure how I can connect with Power BI? Is it even possible without using a third party connector?

PS. I have explored the option to move these flat files to Onedrive and get that from there, however, I do not have access to Power Automate (flow) and approvals for the same so I can't even run a script to move these flat files to OneDrive. 

[Anonymous · Accepted solution]

Hi @Anonymous ,

1. Currently, Power BI doesn't have a native connector for SFTP / FTP sources.

2. To connect to FTP data from Power BI, please refer this document : Use the API Server and FTP ADO.NET Provider in Microsoft Power BI (cdata.com)

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.