Get Data from FTP site

[markt]

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.

[jmac]

You could write a batch file to ftp in, grab the file and bring it to your local server where BI Desktop is running. 

[andre]

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.

[karolis_devyzis]

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

[osinquinvdm]

you need to specify the file, not just the ftp folder. e.g. ftp://ftp.2600.com/whatever.csv

[Anonymous]

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?

[karolis_devyzis]

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