Merge Query OK Button Greyed Out

[UncleLewis]

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

Merge

[PhilipTreacy · Accepted solution]

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

[Icey · Accepted solution]

Hi @UncleLewis ,

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

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 · Accepted solution]

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

[Anonymous]

@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.

[UncleLewis]

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

[Ena]

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