cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Post Prodigy
Post Prodigy

For Folder load only put those file want to load into that folder only ?

Hi All

I am using folder load , i only want to load those txt file which i indicate at Red color box. Does it mean that i should put those text file at one particular folder. So it will only load those text file ?

Paulyeo11_0-1603889619076.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

Hi, @Paulyeo11 

 

The combine files transform behaves as follows:

  • The combine files transform analyzes each input file to determine the correct file format to use, such as text, Excel workbook, or JSON file.

  • The transform allows you to select a specific object from the first file, such as an Excel workbook, to extract.

d1.png

The combine files transform then automatically takes these actions:

  • Creates an example query that performs all the required extraction steps in a single file.

  • Creates a function query that parameterizes the file/binary input to the exemplar query. The exemplar query and the function query are linked, so that changes to the exemplar query are reflected in the function query.

  • Applies the function query to the original query with input binaries, such as the Folder query. It applies the function query for binary inputs on each row, then expands the resulting data extraction as top-level columns.

 

With the behavior of combine files, you can easily combine all files within a given folder if they have the same file type and structure (such as the same columns). So it is unsupported to combine csv files with text file.

 

For further information, please refer to the following document.

Combine files (binaries) in Power BI Desktop 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
Highlighted
Community Support
Community Support

Hi, @Paulyeo11 

 

Based on your descirption, I'd like to suggest you use text filters to get the result.

c1.png

c2.png

c3.png

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted

Hi Sir

Thank you very much for your sharing , when i try to load folder , it just load only CSV file from all the file listed. after i click on Combine and Transform data. it does not load text file.

Paulyeo11_0-1604041951347.png

 

Highlighted

Hi, @Paulyeo11 

 

The combine files transform behaves as follows:

  • The combine files transform analyzes each input file to determine the correct file format to use, such as text, Excel workbook, or JSON file.

  • The transform allows you to select a specific object from the first file, such as an Excel workbook, to extract.

d1.png

The combine files transform then automatically takes these actions:

  • Creates an example query that performs all the required extraction steps in a single file.

  • Creates a function query that parameterizes the file/binary input to the exemplar query. The exemplar query and the function query are linked, so that changes to the exemplar query are reflected in the function query.

  • Applies the function query to the original query with input binaries, such as the Folder query. It applies the function query for binary inputs on each row, then expands the resulting data extraction as top-level columns.

 

With the behavior of combine files, you can easily combine all files within a given folder if they have the same file type and structure (such as the same columns). So it is unsupported to combine csv files with text file.

 

For further information, please refer to the following document.

Combine files (binaries) in Power BI Desktop 

 

Best Regards

Allan

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

Hi Sir

 

thank you very much

just to confirm

So meaning when I need to folder load txt file 

I need to create special folder ?

 

paul

Highlighted

Hi, @Paulyeo11 

 

With the behavior of combine files, you need to create a given folder where there are files with the same file type and structure. So you may create a folder for txt files.

 

Best Regards

Allan

 

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors