Forum Discussion

abc_777's avatar
abc_777
Solution Specialist
5 years ago

Power Bi Matrix

  I have tried many times but when export from power bi service it changes as raw data and not much clear to readable to presentable. can i export power bi matrix data as tabuler form for excle?  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi abc_777 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

 

Best Regards,

Rico Zhou

  • abc_777's avatar
    abc_777
    Solution Specialist
    5 years ago

    The problem is not yet been solved.

     

    This is very simple to query

     

    I am using Power BI Matrix and I have data (customer ID) to column 

    and Customer Name to Row

     

    in field I have sales values.

     

    Then I upload this table to Power Bi service and then from power bi service I export this Matrix as xlsx form using summarize but after exported Rows are in rows but column (customer ID) comes to Rows as well. 

     

    its not in Tabuler form. I also have given a screen shot to understand. and this is really interesting that microsoft has power bi product and MS Office (Excel) product but they dont have this facility to export Power BI Matrix data to Excel (.xlsx) as tabular form. Other side Qlik Sense has this option.

     

    For you understand I again paste matrix table here and when you export this in excel (xlsx) column value goes to row wise