Power query Binary Combine

[dicken]

Can anyone help with this function, I've used it as ;

Binary.Combine( 
 Folder.Files( 
"C:\Users\Richard\OneDrive\Desktop\New folder\New folder") 
                       [Content] )

I've seen a video where this resulted in the actual 'contents ' being combined as tables as would happen with Table.Combine,
I cannot find anything other that ms docs on using this function and they are not much help as they indicate what i have is correct.

Any suggestions ?
Richard.

 

[alansidman]

Are you familiar in PQ with the =#Shared functionality

Once you execute this, then convert to Table and you can look up every PQ functionality.

 

[dicken]

Are you familiar in PQ with the =#Shared functionality

Once you execute this, then convert to Table and you can look up every PQ functionality.

Yes, but not sure how it helps as it help as there is no Binary to table ;
The video I was watching , I don't seem to be able to share the link ended with combined tables
as with Table.combine, I just get a single binary as binary.

RD

 

[GraH]

What are the binary files?

If excel then you can do something like

List.Transform(
Folder.Files(
"C:\Users\Richard\OneDrive\Desktop\New folder\New folder")
[Content] ), each Excel.Workbook(_))
Then combine the tables.

 

[dicken]

Yes but that is not what I watched being done, in the vid it took the list of Binaries, and then used Binary.Combine,
just as Table.Combine would work on a list of table, so ; BInary.Combine ( Sorce [Content] ) ,
this results not in a single binary but as combined table, unless I'm missing something.
I don't seem to be able to share the link but if you wan to have a look youtubue.

Essential Excel
EASY Trick to COMBINE Multiple Excel files into ONE with Power Query

​

Richard.

 

[RoryA]

If you watch it carefully, you will see that additional steps are added automatically as soon as he does the Binary.Combine(Source[Content]) step, the first of which is a Csv.Document step (since he's working with CSV files, not workbooks)

 

[dicken]

If you watch it carefully, you will see that additional steps are added automatically as soon as he does the Binary.Combine(Source[Content]) step, the first of which is a Csv.Document step (since he's working with CSV files, not workbooks)

Thankyou, I thought I must be missing somethin like that.

Richard.