https://www.myonlinetraininghub.com/vlookup-in-power-query-using-list-functions
Hi
I followed the instructions in the link above and it works perfectly! My issue is I use the 2nd file hence why I get the error. How can I do similar to the above without getting the error?
Thank you!
When you connect PQ to data in another file, that other file may not be open when you edit/refresh the queries that connect to that file. You'll get this error:
So, make sure that the 'other' file is closed when you work in the file with the queries.
Thanks
My question is how can I solve my issue? What work around can I do? I use both files
I am weak on PQ
@kasey Oh sorry! I though that was obvious. Close the other file, work on the query(ies), Refresh and the error will not occur.
Yes, obviously. I was hoping for a work around
