Merging Snowflake column and SQL column

[kiru18]

Hi There,

I need your help with an issue I’m facing.

Currently, I’m fetching event data from two sources: Snowflake and an on-prem SQL database. I have joined both tables using the EventID column.

sql result:

Snowflake result:

In my report visual, I’m able to bring in columns from both tables successfully. However, I’m unable to merge the two ID columns into one using the following formula:

      Merge_ID = COALESCE( sql[ID], snowflake[ID] )

The problem is that snowflake[ID] is not recognized or listed in this function.

Could you please help me understand why this might be happening or suggest an alternative approach to merge these columns in the report view?

The expected result :

Thank you.

[v-hashadapu]

Hi @kiru18 ,
I hope the information shared was helpful. If you have any additional questions or would like to explore the topic further, feel free to reach out. If any of the responses resolved your issue, please mark it "Accept as solution" and give it a 'Kudos' to support other members in the community.
Thank you!

[v-hashadapu]

Hi @kiru18 ,
I wanted to follow up and see if you’ve had a chance to review the information provided here.
If any of the responses helped solve your issue, please consider marking it "Accept as Solution" and giving it a 'Kudos' to help others easily find it.
Let me know if you have any further questions!

[Irwan · Accepted solution]

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.

[kiru18]

Hi Irwan,

Thanks for your response. I too tried with Power Qry. But it shows NULL value from Table2.

NOTE: I expect the result like below (the row 'a' has two values. but it has to pick value from table1)

Column1	Column3
a	10
b	20
c	12

Thanks

[Irwan]

hello @kiru18 

null probably because there is no match when merging query.

seems plausible but please share your sample data of sql table and snowflake imported into PQ.

the sample data in your screenshot seems have already been merged (not original data of sql or snowflake)

dont use my example data above, as it is just an example to show merge query.

Thank you.