Forum Discussion

Mai_Nashaat's avatar
Mai_Nashaat
Helper II
5 years ago
Solved

Wrong Data exported from matrix visual

Hi guys, I've a matrix visual that represents data of orders and shipments for customers and products, when I export data from it I got a csv file , when I open it as excel and sum the data in it I ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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. 

     

Mai_Nashaat's avatar
Mai_Nashaat
Helper II
5 years ago

I've no duplicate records and also nt the same values after pivoting them

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Try exporting the data partially and see if it matches. Filter by month or any other parameters and see of teh data matches.

  • Mai_Nashaat's avatar
    Mai_Nashaat
    Helper II
    5 years ago

    The same issue ... really it's weired 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    If possible please send the file after removing confidential information.

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.