Exportar datos en excel desde power bi service - Matriz

[ClaudioL]

Buen dia,

estoy exportando desde power bi service una matriz a excel, se la siguiente manera:

cuando exporta el archivo a excel lo exporta en formato Tabla, y no en formato Matriz como se encuentra creado en power bi:

hay alguna manera de que se exporte el excel en formato Matriz como se encuentra en power bi?

desde ya muchas gracias.

[MFelix · Accepted solution]

Hi @ClaudioL ,

When you do the export of the information in Power BI to excel what you are exporting is the data behind the visualization so you will not export it in the format you have it will always be a table format since each line represents a cell in your matrix.

If you want to have the matrix you need to redo it based on the excel data.

[V-pazhen-msft]

@ClaudioL 

Publish the pbix to Power Bi Service, then you can export the summarize the data to excel. What you did in power bi desktop exported the underlying data.

Export data from a Power BI visualization - Power BI | Microsoft Docs

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[MFelix · Accepted solution]

HI @V-pazhen-msft ,

This is not the solution that @ClaudioL  is expecting if you do this the export of the data comes in an table format in XLS and not on the Matrix format has he is asking.

Please be aware that this type of acceptance of the answers that you give are not correct based on the fact that you are missleading other user that you have a solution for the problem.

Final result will be has below:

Be aware that this is the result given on the export by sumarrization and was by no way changed by me.

[MFelix · Accepted solution]

Hi @ClaudioL ,

When you do the export of the information in Power BI to excel what you are exporting is the data behind the visualization so you will not export it in the format you have it will always be a table format since each line represents a cell in your matrix.

If you want to have the matrix you need to redo it based on the excel data.