Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
kiru18
Frequent Visitor

Merging Snowflake column and SQL column

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:

kiru18_1-1748900782492.png

Snowflake result:

kiru18_2-1748900805997.png

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 :

kiru18_3-1748903889057.png

 

Thank you.

 

 

 

 

1 ACCEPTED SOLUTION
Irwan
Super User
Super User

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

Irwan_0-1748906063729.png

 

- table 2

Irwan_1-1748906086610.png

 

- result

Irwan_2-1748906107766.png

 

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.

Irwan_3-1748906200880.png

 

Hope this will help.

Thank you.

View solution in original post

5 REPLIES 5
v-hashadapu
Community Support
Community Support

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
Community Support
Community Support

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
Super User
Super User

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

Irwan_0-1748906063729.png

 

- table 2

Irwan_1-1748906086610.png

 

- result

Irwan_2-1748906107766.png

 

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.

Irwan_3-1748906200880.png

 

Hope this will help.

Thank you.

kiru18
Frequent Visitor

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)

Column1Column3
a10
b20
c12

 

Thanks

 

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.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors