Forum Discussion
Matrix Table
I need some help and clarifications on getting data of Matrix table.
Let's assume that based on the given data, some matrix table was created with a combination of
selected data with total, subtotal, etc. As we understand, , created table is a virtual table, i.e., calculated figures are not available anywhere.
So , my question is - How can I get data from a virtual table , Matrix table ?
Thank you in advance.
3 Replies
What do you mean by "get" - do you mean export?
Yes, but during "exporting" of data it is impossible to export subtotals, or total figures. Power BI exports just raw and column data.
You could use Analyze in Excel if you are using Excel to recreate the pivot table there with the same measures. That way you wouldnt need to export every time, just refresh. This requires build permission on the dataset.
