Merging Snowflake column and SQL column

hello kiru18 

how about merging those two table in power query after you import those two table (i assumed your report visual is in PBI).

from the screenshot, it should be possible using merge query since merge query can have multiple column to merge.

- table 1

- table 2

- result

as you can see, the row 1 has merged value, however in row 2 it has null because it did not find any same value in both column1 and column2 from table 1 and table 2.

Hope this will help.

Thank you.