Forum Discussion

ayush's avatar
ayush
Frequent Visitor
8 years ago
Solved

Connect Power BI to FTP

Hi All,

     I have .gz files sitting on FTP. Can we directly connect Power BI to FTP? If yes please tell how should I proceed.
     As per my research, we can not directly connect Power BI to FTP so I am trying to connect using R - script present inside power BI but I think R has some data storage limitation (data used by the R visual for plotting is limited to 150,000 rows).

Please let me know any alternate approach.

  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi ayush,

     

    Since Power BI Desktop cannot directly work with FTP sources, what about using FTP commands or third-party tools to bring files down to local folder, then connect to the folder by using the Get Data ->Folder option in Power BI Desktop.

     

    Best  Regards,

    Cherry

4 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Icon for Resident Rockstar rankResident Rockstar
    8 years ago

    Hi ayush,

     

    It's currently possible to use an FTP URL through the "From Web" choice by using an FTP URL. However, this isn't supported when refreshing data in Power BI.

     

    For reference, you could have a  view of this similar thread.

     

    Best Regards,

    Cherry

    • ayush's avatar
      ayush
      Frequent Visitor
      8 years ago

      v-piga-msft Thanks for the help... but I think FTP URL through the "From Web" choice works only for a single file.

      I wanted to import multiple files from FTP.

       

      Thanks,

      Ayush

      • v-piga-msft's avatar
        v-piga-msft
        Icon for Resident Rockstar rankResident Rockstar
        8 years ago

        Hi ayush,

         

        Since Power BI Desktop cannot directly work with FTP sources, what about using FTP commands or third-party tools to bring files down to local folder, then connect to the folder by using the Get Data ->Folder option in Power BI Desktop.

         

        Best  Regards,

        Cherry