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.
Has anyone used PowerBI to Get Data from an FTP site? I basically just need to login and get a listing of files in the folders. I have a C# program that can do this, but I doubt Power BI can call a program.
You could write a batch file to ftp in, grab the file and bring it to your local server where BI Desktop is running.
I just tried it against a public FTP site (ftp://ftp.2600.com/) and although I was able to see the folder structure and select the file, the filed was cashed locally first and loaded in my Power Query. So my guess that refresh from the FTP site would not work.
Hi, Andre,
Could you please help me? I am trying to connect to the same ftp adress you typed, but I receive the message "Details: "Web.Contents failed to get contents from 'ftp://ftp.2600.com/' (0): "
I am connecting through web as a data source.
BR,
Karolis
you need to specify the file, not just the ftp folder. e.g. ftp://ftp.2600.com/whatever.csv
Thanks @osinquinvdm
I was actually trying to access the whole ftp folder but I've discovered that this feature is not still available so you can only access ftp files trough the path to one file. (like you said)
How could I access several files in a ftp in the same query? Is the only option to create individual quearies and then append them all together?
Hi, Andre,
Could you please help me? I am trying to connect to your named ftp adress, but I get this message "Details: "Web.Contents failed to get contents from 'ftp://ftp.2600.com/' (0): "
I am connecting through web as a source.
Thanks,
Karolis
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.