Merged Queries Fails

[Anonymous]

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:

1. "Merged Queries" take the Product table and perform a Left Outer JOIN with the Customer table, with "ProductID" as the key.
2. 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?

[Anonymous · Accepted solution]

It ended up being a blank value, I filtered out blanks and the problem went away.

[AbhinavJoshi]

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