Forum Discussion
data from two tables in one gallery
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.
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.
1 Reply
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.