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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
UncleLewis
Resolver III
Resolver III

Merge Query OK Button Greyed Out

Hi all,

 

I am trying to create a Merge Query in Power Query using Fuzzy Match

Howerver, as soon as I click on the Merge Queries Button, the dialog opens, but the OK Button is greyed out. and I see a warning exclamation on one of my tables.

 

How can I create a Merge Query?

 

thanks

-w

 

MergeMerge

2 ACCEPTED SOLUTIONS
PhilipTreacy
Super User
Super User

Hi @UncleLewis 

When you have a query selected, then click on Merge Queries, you'll get that yellow warning triangle on the query appearing.

In the Merge dialog box you need to choose the 2nd table and then click on the columns that you will be using to do the Join, then the OK button will become yellow as you will have done everything you need to actually run the merge.

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

Icey
Community Support
Community Support

Hi @UncleLewis ,

 

Just like what @PhilipTreacy mentioned, please click on the columns used for merge like below and accept his reply as the solution.

merge.JPG

 

In addition, some documents for reference:

Merge Operations in Power BI / Power Query – Part 1: Left Outer Join;

Append vs. Merge in Power BI and Power Query.

 

 

 

Best regards

Icey

 

If this post helps,then consider Accepting it as the solution to help other members find it faster.

View solution in original post

10 REPLIES 10
jch2s
New Member

I now have the same problem:

jch2s_0-1724688248200.png

 

jch2s
New Member

I am also now just having this issue. I am on the July 2024 version.

Silly mistake. I already had a merge between those queries that showed up with a warning triangle. All fixed.

Ena
Frequent Visitor

Yeah... The devil is often in the details.

Ena
Frequent Visitor

Post a screenshot, include the toolsbar.

Icey
Community Support
Community Support

Hi @UncleLewis ,

 

Just like what @PhilipTreacy mentioned, please click on the columns used for merge like below and accept his reply as the solution.

merge.JPG

 

In addition, some documents for reference:

Merge Operations in Power BI / Power Query – Part 1: Left Outer Join;

Append vs. Merge in Power BI and Power Query.

 

 

 

Best regards

Icey

 

If this post helps,then consider Accepting it as the solution to help other members find it faster.

PhilipTreacy
Super User
Super User

Hi @UncleLewis 

When you have a query selected, then click on Merge Queries, you'll get that yellow warning triangle on the query appearing.

In the Merge dialog box you need to choose the 2nd table and then click on the columns that you will be using to do the Join, then the OK button will become yellow as you will have done everything you need to actually run the merge.

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Anonymous
Not applicable

@UncleLewis Please select the table you want to merge in the section with text "No preview is available".

For more information, please visit:

https://radacad.com/append-vs-merge-in-power-bi-and-power-query

 

 

 

 

Please mark my reply Accepted if I solved your problem.

Thanks,

 

Sorry, that does not resolve the problem.

I think it has to do with the warning symbol on one of the tables.

I don't knwo why the warning is there.

As soon as I cancel out of the Merge Query, the warning goes away.

 

thanks

-w

 

 

 

 

 

Merge2.png

Did you ever find a solution? I am having the issue now.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.