Forum Discussion
Merged Queries Fails
I've got a Product table and a Customer table.
Product Table:
| ProductID | Product |
| 01 | Microwave |
| 02 | Television |
| 03 | Phone |
| ... | ... |
Customer Table:
| CustomerID | Name | ProductID | Region |
| A | 02 | SE | |
| B | Linda | SW | |
| C | Christopher | 07 | NE |
| ... | ... | ... | ... |
I perform the following power query M steps:
- "Merged Queries" take the Product table and perform a Left Outer JOIN with the Customer table, with "ProductID" as the key.
- Expand the Customer table, deselect "use table name as prefix", only expand the "CustomerID" and "Name" columns.
When I perform step #2 I get the error:
Expression.Error: The 'offset' argument is out of range.
Details:
3
What can I do to fix this issue?
2 Replies
Hello Anonymous. I tried replicating it with the minimal dataset it provided me and worked for me. Can you please provide the full M code?
This is what my final table looks like
Customer Table
Merge settings
It would be great if you can provide some more context,
Thanks,
Abhinav
