Forum Discussion
Power Query Error - Duplicating Queries
- 2 years ago
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 ash12486
I've never had this issue either. This looks weird. Based on the number at the end of each query name, it seems that each query is not duplicated the same number of times. If these queries were only duplicated, removing the ending numbers in query names should bring everything back to work again.
Best Regards,
Jing