Forum Discussion
Power Query Error - Duplicating Queries
Hi Jing, thank you for responding! You are correct, I forgot to mention in my original post that everything was able to pretty quickly be fixed by removing the (#). But the root issue was driving me crazy, because it was happening more and more frequently.
Upon further investigation, I believe I’ve identified the root cause of this issue. I wanted to share my findings in case anyone else encounters a similar problem.
During a walkthrough with the user, it became clear that they were copying audit results to another worksheet without pasting the data as values. Each time they did this, they inadvertently copied the query as well. Although we’ve only recently deleted those query copies, it seems quite plausible that this was the underlying reason for the recurring issue.
Hi Jing, thank you for responding! You are correct, I forgot to mention in my original post that everything was able to pretty quickly be fixed by removing the (#). But the root issue was driving me crazy, because it was happening more and more frequently.
Upon further investigation, I believe I’ve identified the root cause of this issue. I wanted to share my findings in case anyone else encounters a similar problem.
During a walkthrough with the user, it became clear that they were copying audit results to another worksheet without pasting the data as values. Each time they did this, they inadvertently copied the query as well. Although we’ve only recently deleted those query copies, it seems quite plausible that this was the underlying reason for the recurring issue.