Forum Discussion

amarlian's avatar
amarlian
New Member
2 years ago
Solved

Duplicate Column Name in table error without any duplicate names

Hello, I am new to powerbi but I am now having an error appear that is frustrating and I cannot figure out how to stop it. Scenario: I am pulling data in from a website json file as a data source ...
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi,  amarlian 

    Your solution is great iluvaccounting1  . After my testing, this bug does exist in the new version. The main reason for this bug is that when we click on another column, we click on the original column again, and the corresponding formula is copied.I created a new table with summarize, and then created a new calculated column in this table:

     

    When clicking on another column and then clicking on the original column, we get an error, and we find that the formula of the original new column has been replaced, as shown in the image below:

    You can avoid this problem by clicking on these columns carefully. In addition, you can download an older version of Power BI to use.

     

     

     

    How to Get Your Question Answered Quickly

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

    Best Regards

    Jianpeng Li

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.