Forum Discussion

saud968's avatar
saud968
Memorable Member
2 years ago
Solved

Export data in csv is missing data

The count is supposed to be 25041, however, when I exported the data it shows only 2150 count rows. I have created a bridge table to avoid many to many relationship issues, however, i am fac...
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi saud968 ,

     

    Can you try to export using DAX Studio? This method can even export the whole model at once.

     

    For more details please see:

    Exporting all data from a Power BI data model – XXL BI


    Do not apply any Filter or Slicer while exporting.

     

    If you have any other questions please feel free to contact me.

     

    Best Regards,
    Yang
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

  • saud968's avatar
    saud968
    2 years ago

     I was able to fix this by creating new calculated columns 

    CES Question = CALCULATE(
            MIN('Merge1'[CES Question]),
            TREATAS(VALUES('support__cw_ops_manage_case_merge'[ID]), 'Merge1'[CASE_NUMBER])
        )

    This gives me the exact count as needed. 
AnushaSri's avatar
AnushaSri
Resolver II
2 years ago

I can see in your data image - it is showing some duplicate rows, so probably it might have eliminated duplicate rows.

  • saud968's avatar
    saud968
    Memorable Member
    2 years ago

    I do agree but they should not be removed, also even if it is removed they should not be 2150. what I found that it is only export data from the one of the table Merge1 and not overall