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. 
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi saud968 ,

 

Thanks for the reply from AnushaSri .

 

The problem may be related to how you aggregate or filter the data before exporting, because you mentioned that your data is 25,041 rows, but the maximum number of rows that Power BI Desktop can export to a CSV file is 30,000 rows.

 

This can be checked in the following ways:

 

  1. Whether Slicer or Filter is applied.

 

  1. Consider exporting the data to Excel first and then save the Excel file as CSV.

 

For more information on Power BI Desktop export to CSV file see:

Export data from a Power BI visualization - Power BI | Microsoft Learn

 

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
Memorable Member
2 years ago

So I have tried to export it via Power BI service and Desktop both but the output remains the same. The only filter is the slicer with year and month. It seems when exporting it only gives the count from the Merge1 table and not support__cw_ops_manage_case_merge. Whereas I am expecting all the counts from support__cw_ops_manage_case_merge. So in my table visual I have added 4 columns from the Merge1 table rest of the columns are from support__cw_ops_manage_case_merge. 

Hope this gives more clarity to help me out...Thank you for all the support 🙂

  • Anonymous's avatar
    Anonymous
    Not applicable
    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!