cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UncleLewis
Helper III
Helper 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

4 REPLIES 4
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

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

PoojaShri
Resolver II
Resolver II

@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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors