March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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.
I now have the same problem:
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.
Yeah... The devil is often in the details.
Post a screenshot, include the toolsbar.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
62 | |
55 | |
27 | |
17 | |
11 |