Export data in csv is missing data

[saud968]

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 facing the issue mentioned above help advice.

@Ritaf1983 @lbendlin @Ashish_Mathur @Greg_Deckler @amitchandak @Idrissshatila @Ahmedx @Daniel29195 

[Anonymous · Accepted solution]

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 · Accepted solution]

 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]

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.

2. 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]

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 · Accepted solution]

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!

[AnushaSri]

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

[saud968]

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