- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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 ?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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.

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
08-22-2022 06:33 AM | |||
08-22-2022 06:30 AM | |||
03-17-2025 09:26 PM | |||
08-30-2018 11:51 AM | |||
Monday |
User | Count |
---|---|
33 | |
18 | |
14 | |
11 | |
10 |