Merge Query OK Button Greyed Out

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

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.