Duplicate value

[Archie-gh]

Hi all, 

I have an issue in reporting from project online via pwoer bi, 

the projects have more than one baseline whihc cause to have duplication in project Id like this as number of baseline is showing in another column. that should be duplicated as many other columns have differernt value in one project Id. 

when I refresh it, I see this error and I tried to change relationships many time, but non of them worked. also, I deactive relationships or disbale to load the table, I see still the error, can anyone helpe me? 

I need to have the basline numbers in my reporting. 

[v-yangliu-msft]

Hi  @Archie-gh ,

You can try the following methods:

1. Remove duplicate rows in Power Query and try again.

2. Remove all these unnecessary created relationships, and also turn off the "Auto-detect relationship" function

https://radacad.com/power-bi-design-tip-disable-the-auto-detect-relationship

Best Regards,

Liu Yang

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

[Anonymous]

Hi, 
Are u using a single table or multiple tables for this project? If ur TaskBaselines is a separate table then first find a unique id for baseline number. Or u can use remove duplicates in transformation data.

[amitchandak]

@Archie-gh , Change relation to many to many or remove that.

Also, validate in the property pane of the Data model view, By selecting this table. Is projected marked as the key column, if yes set it none

[Archie-gh]

Hi Amitchan

that doesn't work, 

key column is like this