Forum Discussion
Unwanted duplicated rows in visual table
Hi,
Sorry for my late answer.
As I have live datasets I tried to embed the data directely within the pbix and I figured out that my duplicated rows issue was gone.
So I must say that it looks like a bug when having a relationship between 2 tables from live powerbi datasets.
Problem is solved at the moment as I have embed everything within the same pbix.
But if you want to reproduce, you can try to link 2 live datasets and make a relationship between them, then display the result in a visual table.
Super UserDarats , In such cases it is better to create one or more bridge table like ref_user in this case and use that
https://www.seerinteractive.com/blog/join-many-many-power-bi/
refer to my video on how to create Bridge Table: https://www.youtube.com/watch?v=Bkf35Roman8&list=PLPaNVDMhUXGaaqV92SBD5X2hk3TMNlHhb&index=19
Hi,
I did follow your tutorial and try to create a Bridge table before, I didn't succeed and there came back with the many to many relation.
I've made a Bridge table : DISTINCT ( UNION ('Table 1','Table 2') ).
I wasn't able to append Table 1 and Table 2 because I cannot have them in power query because they are PBI Datasets
Here are the results I got :
Bridge + Table 1 and Bridge + Table 2 works but I still have those duplicated rows problems (yellow above).
Table 1 + Table 2 : gives an error, which I don't understand why.
I still believe those duplicated rows are not normal, any idea?
v-deddai1-msftCommunity Support
Hi Darats ,
You can learn more about many to many relationship from https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-many-to-many-relationships and https://docs.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many
Would you please show us sample pbix contains table1 and table2?
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi,
Sorry for my late answer.
As I have live datasets I tried to embed the data directely within the pbix and I figured out that my duplicated rows issue was gone.
So I must say that it looks like a bug when having a relationship between 2 tables from live powerbi datasets.
Problem is solved at the moment as I have embed everything within the same pbix.
But if you want to reproduce, you can try to link 2 live datasets and make a relationship between them, then display the result in a visual table.