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 ...
  • 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

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