Forum Discussion
Export data in csv is missing data
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 TeamIf 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!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.
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 🙂
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!