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.
in the visual I'm just using measures, and I don't have options when exporting data just this snapshot
Once you click the export you will see as below
If you have used measures, underlying data will be enabled. You can selelct this option to see all the underlying records.
If you are exporting the data from power bi service,make sure below setting is enabled for the report. You get this option on the settings of the report
yes I make it in power bi service but now how can I fix this in power bi desktop
Are you facing this issue when exporting from power bi service?
first I found the issue in desktop but when I tried te steps mentioned in service and exported the data it was ok but I still didn't solve the issue in the desktop