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.
Community SupportHi 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.
- v-deddai1-msft
Hi Darats ,
Thank you for sharing the solution. One thing need to be confirmed, if the two tables from different live connection data source, then the issue happens.
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