Power Query ; From Folder

[dicken]

Hi
When using From Folder ; I always get both 'sheet' and 'table' but when watching quite a few tutorials this does not seem to be the case,

my usual approach is
From Folder ;

Folder.Files("C:\Users\Name \OneDrive\Desktop\New folder\New folder")

Then either trans form of add column

Table.TransformColumns(  Source, { "Content", each Excel.Workbook(_) } )

So now for each Table in the content column, I have two rows one for Table and one for sheet;
is there a way to deal with the source excel table / sheets to only bring in one or the other, they both contain the tables I want?

Richard

 

[Matt Allington]

I’ve never seen the behaviour that you describe here. Take a look at my article here and it will help you understand how it works. Understanding Power Query Combine

normally what happens is, there are two main queries that are generated, the sample query and the combine query. The sample query should select either table or sheets which is not what you’re describing. Maybe you were doing it manually. So the solution is to make sure that your second query, the file combine query, is pre-filtered so that only a list of either sheets or tables are passed to the function.

 

[dicken]

I’ve never seen the behaviour that you describe here. Take a look at my article here and it will help you understand how it works. Understanding Power Query Combine

normally what happens is, there are two main queries that are generated, the sample query and the combine query. The sample query should select either table or sheets which is not what you’re describing. Maybe you were doing it manually. So the solution is to make sure that your second query, the file combine query, is pre-filtered so that only a list of either sheets or tables are passed to the function.

Hi Matt,
I'm not using the combine option, jus as the stage below selecting transform,

View attachment 93826

And then

Table.TransformColumns(  Source, { "Content", Excel.Workbook} )

To get the table


View attachment 93828

I’ve never seen the behaviour that you describe here. Take a look at my article here and it will help you understand how it works. Understanding Power Query Combine

normally what happens is, there are two main queries that are generated, the sample query and the combine query. The sample query should select either table or sheets which is not what you’re describing. Maybe you were doing it manually. So the solution is to make sure that your second query, the file combine query, is pre-filtered so that only a list of either sheets or tables are passed to the function.

Hello Matt,
Yes, I know the pane you mean about selecting table, so in your arcticle

When given the option, I select the Combine button (combine and edit).
I'm selecting edit / transform. and then using excel.workbook to get at the binary,

RD