Forum Discussion
Duplicate value does not allow me to progress with my data transformation.
Hi I am trying to tarsform my data in Power BI but when I apply my chages it stops me with this message that one of my columns "contains a duplicate value '0' and this is not allowed for columns on ...
In PowerQuery view go to 'Add Column', click on 'Index Column'. Close PowerQuery and go to the modeling view. Click on the table and in properties set the Index Column you have just created as Key column