Forum Discussion
Solved
Cyclic reference in Power Query - How to avoid?
Hi All, So, rather than show a bunch of code and images, I want to try to just explain the problem and see what options there are to deal with it. I query SQL Server for a list of about 2K emplo...
Maybe if these are steps within same query. I meant you have separate queries. In general it's always good practice to make operations with separate tables as join, combine, etc as separate queries. With that it shall if on final steps you use references, not initial queries.
Thank you Sergei. I was able to get it to work by simply making the anti-joins to the PP table use a connection only to the PP table whereas when I append to the PP table it is actually linked to and updating the table in Excel.
Great to know it works, thank you for the update.