Forum Discussion
Wrong Data exported from matrix visual
Hi Mai_Nashaat
Now you are trying to export data from visualization, and you said that you will get wrong sum result with summarize data in Power BI Desktop.
In Power BI Service you followed the steps as SubinPius mentioned in his reply to export underlying data from visualization and it worked.
I think your issue can be resolved by exporting underlying data from your Matrix.
In Power BI Desktop, you'll only have the option to export summarized data as a .csv file.
So if you want to export underlying data from your visualization, you can do it in Power BI Service.
For reference: Export the data
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check for any duplicate records in the table.
You can also try creating a pivot in the excel and see if its matching with the matrix.
Please mark it as a solution if it serves your purpose.
I've no duplicate records and also nt the same values after pivoting them
Try exporting the data partially and see if it matches. Filter by month or any other parameters and see of teh data matches.
The same issue ... really it's weired
If possible please send the file after removing confidential information.
Hi Mai_Nashaat
Now you are trying to export data from visualization, and you said that you will get wrong sum result with summarize data in Power BI Desktop.
In Power BI Service you followed the steps as SubinPius mentioned in his reply to export underlying data from visualization and it worked.
I think your issue can be resolved by exporting underlying data from your Matrix.
In Power BI Desktop, you'll only have the option to export summarized data as a .csv file.
So if you want to export underlying data from your visualization, you can do it in Power BI Service.
For reference: Export the data
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.