Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Duplicate/Repalce Value Column Error

Hi All,

 

I have a problem when I duplicate or replace values in a column within PowerBi and refresh I receive the below error

 

My data source is a sql DB and it is configured to import the data instead of direct connection.

 

image.png

5 REPLIES 5
TeigeGao
Solution Sage
Solution Sage

Hi @Anonymous ,

Could you please check the verrsion of PowerBI? If it is not the latest one, please upgrade it. This problem occured in PowerBI of previous version, but this problem has been fixed in the later version, besides, I can't reproduce this problem in the latest version.

Best Regards,

Teige

Anonymous
Not applicable

Hi @TeigeGao I am on the latest powerbi version: 2.71.5523.821 64-bit (July 2019)

 

Hi @Anonymous I have removed all the relationships and still get the same error.

Anonymous
Not applicable

@Anonymous ,

 

I believe column you are replacing values is primary key and already has relationship with another table.

 

Remove the previous Table relationships if you don't need it.

 

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

Anonymous
Not applicable

Hi @Anonymous 

 

The column has no relationship to any other tables. I've also tried duplicating the column and receive the same error.

Anonymous
Not applicable

@Anonymous ,

 

Remove all relationships linked to this table or Reload same data with other name. Problem is due to Unique key either in the target column or another column. Please provide sample snap of data and relationship pane for RCA.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.