Request to Business Central and union more tables

[Z_BI]

Hi community, 

I'm working on a report with several query. 

One of this query make 1 request to Business Central (by O.Data) for each company and in the next step add a custom column. In total 4 company.

I would like to have one request including all 4 tables (which have the same data structure).

Obviously the problem is the amount of time it takes to update it.

Please help me

[v-yanjiang-msft · Accepted solution]

Hi @Z_BI ,

According to your description, if you want to union the 4 tables in a vertical orientation, add a step:

#"Appended Query" = Table.Combine({VENDORLEDGSR1, VENDORLEDGSR2,VENDORLEDGSR3,VENDORLEDGSR4})

If you want to union the 4 tables in a horizontal orientation, add three steps:

#"Merged Queries" = Table.NestedJoin(VENDORLEDGSR1, {"Name"}, VENDORLEDGSR2, {"Name"}, "VENDORLEDGSR2", JoinKind.LeftOuter),
#"Merged Queries1" = Table.NestedJoin(#"Merged Queries", {"Name"}, VENDORLEDGSR3, {"Name"}, "VENDORLEDGSR3", JoinKind.LeftOuter),
#"Merged Queries2" = Table.NestedJoin(#"Merged Queries1", {"Name"}, #"Appended Query", {"Name"}, "VENDORLEDGSR4", JoinKind.LeftOuter)

Then expand the columns.

I attach my sample below for your reference.

Best regards,

Community Support Team_yanjiang

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