Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

How to connect to a FTP using Power BI

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. 

Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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.