Table.Combine: Combine all queries in a group

[Anonymous]

Hello,

Our organization has a few reports that need a static lookback at results for each of our fiscal periods. An example is our accounts recevables aging list. It needs to be pulled each month and then combined to show our monthly aging schedules. 

I was wondering if there is a way to reference a power query group (an organized group of queries) so that we don't have to manually type each query name in Table.Combine() when we upload a new month? If not, should we submit a request to get this feature added?

I've researched this for about an hour and haven't come up with anything yet! Hopefully you guys can help out?

[Tonio_EG]

Hi, have you figured out a way to do this?

[v-shex-msft · Accepted solution]

Hi @Anonymous,

Can please share some dummy data with a similar data structure? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

BTW, if your files are stored in a folder, you can try to use a folder connector to get the list of first and direct use combine function with that file lists. (Table.Combine function use list as the parameter, you can try to use 'source name' and 'column name' to extract the file list)

let
    Source = Table.Combine(QueryName[ColumnName])
in
    Source

M query operator 
Regards,

Xiaoxin Sheng

[PhilipTreacy]

@Anonymous 

How are you loadng all these tables?  Are they from files or a folder?

Have you tried the Folder connector which allows you to easily combine files in the way you are describing?

regards

Phil