Forum Discussion
Solved
Connect PowerBI to FTP
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 creatin...
v-luwang-msft Andreas_O MathiasMÜ Thank you! i will try moving it to a sharepoint folder
Unfortunately nothing changed in the last 4 years. You can not handle FTP servers as a source.
Your options are:
- Connect to the FTP with your computer and map the folder as a network drive, as described in the link above. With this and a personal gateway you can access the files and refresh in the service, as long as your computer is running.
- If you/ your company is already using Azure services, you could transfer the files (using or example Azure Data Factory, or just a powershell script on any computer) to a Azure Blob Storage/ Data Lake and query them directly with Power BI from there.
Best regards
Mathias
I'd like to add option 3. We watch our SFTP via Power Automate and upload any new incoming file to a SharePoint Folder
That works pretty well, but it could certainly be easier