Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hiya good people of PQ,
I am trying to rename a few nested tables as below :
I am using the following steps :
Table.AddColumn(#"Removed Columns1", "TableRenames", each Table.RenameColumns([ChangedFKHeaders],Table.ToRows(Headers),MissingField.Ignore))
but :
bcos a few of the tables have the same column name, I am getting the followng error :
Is there any fix for this unless I am missing something obvious?
any help appreciated
Hi @monojchakrab ,
This error is because you are adding a column named "value", but this column already exists in your table. You need to check your table to see if there is already a column named "value".
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-stephen-msft - Stephen....that is what is confusing. The table returning the error does not actually contain any column with header as "Value"
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.