I have a query that then has a query that references it.
I've logged on to a different computer - the original query works fine but the one referencing it (that did work fine) comes up with the error
"Expression.Error: The key didn't match any rows in the table.
Details:
Key=Record
Table=Table"
I've copied the query from the Advanced editor - apart from the source line which just says Source = Query1, and created a new query referencing the original, pasted the code from the one that doesn't work and this one works fine?
What can the error be when the "Master query" works fine?
Does the other computer have access to the file path the original query is referencing? And does the other computer have the same version of Excel and Power Query?
They are in the same folder and both use office 365.
So if you look at Query 1 (the original query) on the 'other computer' it shows the query results, it's only Query 2 that is returning the error?
What happens if you create another query (Query 3) that references Query 1 on the 'other computer'? If it works, can you compare the code from Query 2 and Query 3 in the advanced editor to see if anything appears different.
Yes Query 1 works on the other computer and shows the query results it's only Query 2 that is returning the error.
I created a Query 3 again referencing Query 1 by copying the code from the Advanced editor except I re-typed Source = Query1 and that worked fine.
Could it be something quirky when using a Terminal Server profile?
