Power Query merge query on two colums

Question

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:

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

Answer 1

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  

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.