Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Duplicate value

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. 

 

Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    Anonymous , 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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Hi Amitchan

      that doesn't work, 

      key column is like this 

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi  Anonymous ,

    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.