Forum Discussion
Solved
Error when duplicate query
Anyone encounter the problem in power query editor when you right click and duplicate a query, and it says key already exisit. When you click cancel, the whole power query still collapse and you hav...
Hello Tom_Y
When you duplicate a query, Power BI shows an error like:
“Key already exists”
Then it freezes or crashes, forcing you to exit Power Query without saving changes.
Try this
Open the query you want to duplicate.
Go to Advanced Editor.
Copy all the M code.
In Power Query, go to Home > New Source > Blank Query.
Open Advanced Editor of the new query and paste the code.
If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Hi Tom_Y ,
We wanted to kindly follow up to check if the solution provided for the issue worked? or Let us know if you need any further assistance?
If our response addressed, please mark it as Accept as solution and click Yes if you found it helpful.
Regards,
Chaithra.