Forum Discussion
Get Data from FTP site
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.
6 Replies
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 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
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
You could write a batch file to ftp in, grab the file and bring it to your local server where BI Desktop is running.
