Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

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,...
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.           

     

     

     

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.