data from two tables in one gallery

[Syndicate_Admin]

hi Team,

I have a requirement where I need to create one gallery, this gallery should contain the data from two Azure SQL tables, TableA, TableB

Schemas of TableA is

TableA : (colA: string, colB: string, colC: int........)

TableB: (colA`: string, colB: bool..........)

ColA and ColA` will contain same value

for a value in colA, there can be multiple entries in TableB

In my gallery I want to display like

ColA, ColB, trueCountFromTableB, falseCountFromTableB, colC

Can someone suggest how to achieve this.

[Anonymous · Accepted solution]

Hi @anampelly,

You can try 'Merge Queries' in Power Query Editor. A merge queries operation joins two existing tables together based on matching values from one or multiple columns. You can choose to use different types of joins, depending on the output you want.

Merge queries overview - Power Query | Microsoft Learn

Best Regards,

Stephen Tao

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