Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Dear Members,
I am getting below error while renaming the columns names using renamed table list.
Expression.Error: The field 'Stock_Code_No.' already exists in the record.
Details:
Name=Stock_Code_No.
Value=
Below is the SS of power query error.
Requesting for your assistance.
Thank you,
Harmeet
Solved! Go to Solution.
Hi @Harmeet25 ,
The reason is that the renamed column name duplicates the column name of another column in the table.
Check the logic or catch the error.
each try Table.RenameColumns([Legit Col Count],Table.ToRows(Renames),MissingField.Ignore) otherwise [Legit Col Count]
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @Harmeet25 ,
The reason is that the renamed column name duplicates the column name of another column in the table.
Check the logic or catch the error.
each try Table.RenameColumns([Legit Col Count],Table.ToRows(Renames),MissingField.Ignore) otherwise [Legit Col Count]
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Thank you Gao for your support. Really appreciate.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |