Connect Power BI to FTP

[ayush]

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.

[CN186104]

Hi:  There is an idea posted in the community that you can vote on:

https://ideas.powerbi.com/ideas/idea/?ideaid=041af235-6195-40fa-94b7-34cb1960aeec

It needs a lot more votes to be considered... but this would be a great addition.

[v-piga-msft]

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]

@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 · Accepted solution]

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