Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 creating a batch file that copies and pastes all the files from the FTP folder into another location but this doesn't continue to work when I am signed off of the computer.
Thank you!!
Solved! Go to Solution.
Hi, @mkurup12
As a workaround, you can use the CData ODBC Driver for FTP (Third-Party Platform ) to visualize FTP data in Power BI Desktop and then uploading to the Power BI service.
See the links below for more details on how to connect to FTP as an ODBC data source.
Author and Share Power BI Reports on Real-Time FTP Data
Best Regards,
Community Support Team _ Eason
If you have an access to a Sharepoint folder and Power Automate, you can automatically move the FTP files to a SharePoint folder as they arrive and use SharePoint connection instead. There is already an existing template (which you might need to modify) in Power Automate that can do this.
Proud to be a Super User!
Hi, @mkurup12
As a workaround, you can use the CData ODBC Driver for FTP (Third-Party Platform ) to visualize FTP data in Power BI Desktop and then uploading to the Power BI service.
See the links below for more details on how to connect to FTP as an ODBC data source.
Author and Share Power BI Reports on Real-Time FTP Data
Best Regards,
Community Support Team _ Eason
@mkurup12 , might not connect directly
refer
https://community.powerbi.com/t5/Power-Query/Connect-to-FTP-folder-with-txt-files/m-p/2503750
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |