Forum Discussion

markt's avatar
markt
Regular Visitor
11 years ago

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...
andre's avatar
andre
Memorable Member
11 years ago

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's avatar
    karolis_devyzis
    Regular Visitor
    9 years ago

    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

  • karolis_devyzis's avatar
    karolis_devyzis
    Regular Visitor
    9 years ago

    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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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?