Share via

Power Query merge query on two colums

KBD 80 Reputation points
2024-09-20T21:53:31.9466667+00:00

Hello:

I have two datasets (UserQueries) in Power Query, I now want to merge them on two columns that are common. Should be easy, right.

I use Merge Queries on the tool bar, get a dialogue box as follows:

User's image

The col's are correct and the order is correct. Number of matches is correct.

Now I have a Merged Queries step with code as follows:

Table.NestedJoin(#"Added custom 6", {"ASSETNUM", "recordTag"}, UserQuery, {"ASSETNUM", "AssetMax"}, "UserQuery", JoinKind.Inner)

But I get the following error:

UserQuery (2) : Expression.Error: Nested Joins must be expanded.

Googling this error did not return any helpful results.

Your kind assistance is requested

KD

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,842 questions
Accepted answer
  1. Chandra Boorla 2,990 Reputation points Microsoft Vendor
    2024-09-23T11:37:02.9133333+00:00

    Hi @KBD

    Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

    MS Fabric is currently not supported in the Q&A forums, the supported products are listed over here Supported products on MS Q&A (more to be added later on).

    You can ask the experts in the dedicated MS Fabric community forum.

    Can you please open as a new thread in MS Fabric Community: https://community.fabric.microsoft.com/t5/Power-BI-forums/ct-p/powerbi  

    User's image

    Hope this helps. Do let us know if you have any further queries.

    If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.