Forum Discussion
change primary key power bi
Hello, Anyone can tell me how we can change a colomn of Primary key in Power BI, I have a table with 2 Colomn, i like to add an Index colomn and specify it to primary can, i can't do it. Tha...
To get around this issue, I added a Step in my Query to remove duplicates on the particular column... this allowed me to successfully apply the query. Then I loaded the data model, deleted the relationship. Next I went back in and removed my Query Step: Removed Duplicate to bring back to the original table and now I am reapplying the proper relationship. Phew! Problem solved. :)
It is likely because of the cardinality of your table relationship. Try changing either from Many:One to One:Many (or vice versa).
Also, make sure the cross filter direction is set to single instead of both. The direction should be Dim > Fact.