Issue in export data in power bi

[anonymus]

Hello, I am new to power bi. I have built a matrix out of two different table which have one to many relationship. When I drill down in the matrix I am not getting duplicates rows  in power bi desktop .When I try to export the data to excel or csv format the rows is getting duplicated .Please give some solutions All  suggestions are welcome thank you in advance!!

Below is the Screenshot. The Red colour in the refrence number are duplicated.

Regards,
Anonymus

[anonymus]

Issue is resolved

Thank you

[anonymus]

Hello,

I tried with the above method but duplicate rows is still existing in the export data .
I am attaching a file for better understanding .

Index value 3 is incorrect and apprears each  time if I filter for different receivable.

Please suggest any alternate solutions for the issue. Any suggestions are welcome.
Thanks

[lbendlin · Accepted solution]

When you export to Excel choose "with current format". Or use "live connection" which also replicates the DAX query for the visual.