Reply
TonyHansson
Frequent Visitor
Partially syndicated - Outbound

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:password@ftp2-internal.gategroup.com/P07/

 

Using the get data from text/csv.

 

I want power query to access the folder, so I can choose the neewest file, but this is not working, using get data from folder:

 

= Folder.Files("\\ftp://username:password@ftp2-internal.gategroup.com/P07/")

 

Can I do this ?

1 ACCEPTED SOLUTION
Vijay_A_Verma
Super User
Super User

Syndicated - Outbound

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.

View solution in original post

2 REPLIES 2
TonyHansson
Frequent Visitor

Syndicated - Outbound

Hi @Vijay_A_Verma 

 

Thank you for your help, I will not use more time on this.

 

Regards

 

Tony

 

Vijay_A_Verma
Super User
Super User

Syndicated - Outbound

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.

avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)