Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to 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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHI @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português
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.
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
59 | |
51 |
User | Count |
---|---|
165 | |
83 | |
68 | |
68 | |
59 |