Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Proud to be a Super User!
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.
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.
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
Proud to be a Super User!
@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
Did you ever find a solution? I am having the issue now.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.