Forum Discussion

TonyHansson's avatar
TonyHansson
Frequent Visitor
4 years ago
Solved

Connect to FTP folder with txt.files

Hi   I have succesfully connected PowerQuery to a specific txt. file on a FTP server, using the username and pasword:   ftp://username:[email protected]/P07/   Using the get ...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Folder.Contents or Folder.Files is not supported for ftp sources. However, you can connect to a single file through ftp source which you have been doing.

    The only way out is to get the files down to a folder on a local machin/network machine/Onedrive/Sharepoint etc.

    You will have to constantly query ftp to locate the change/new files and download them. Consult thread where Microsoft Flow has been used for this purpose -  https://community.powerbi.com/t5/Power-Query/connection-with-ftp/td-p/91792 

    But if this is a once or twice a day sort of operation, just download the files and use the downloaded files through Folder connectors.

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Folder.Contents or Folder.Files is not supported for ftp sources. However, you can connect to a single file through ftp source which you have been doing.

The only way out is to get the files down to a folder on a local machin/network machine/Onedrive/Sharepoint etc.

You will have to constantly query ftp to locate the change/new files and download them. Consult thread where Microsoft Flow has been used for this purpose -  https://community.powerbi.com/t5/Power-Query/connection-with-ftp/td-p/91792 

But if this is a once or twice a day sort of operation, just download the files and use the downloaded files through Folder connectors.