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. 
saud968's avatar
saud968
Memorable Member
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.