Forum Discussion

anonymus's avatar
anonymus
Frequent Visitor
3 years ago
Solved

Issue in export data in power bi

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

Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

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

3 Replies

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    3 years ago

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

  • anonymus's avatar
    anonymus
    Frequent Visitor
    3 years ago

    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