topic Power BI Export Matrix/Pivot table in Table Form instead same visual form in Developer

Power BI Export Matrix/Pivot table in Table Form instead same visual form

Seemaa — Mon, 27 Sep 2021 10:29:07 GMT

I have data in matrix visual as below format:

Location / Department	HR	IT	Finance	Admin	R&D
Mumbai	50	100	60	20	10
Delhi	40	80	50	30	10
Bangalore	25	90	40	20	15
Hyderabad	30	70	30	10	12
Chennai	25	30	20	15	10

When I was export data of matrix visual in excel I get the below format:

Location	Department	Headcount
Mumbai	HR	50
Mumbai	IT	100
Mumbai	Finance	60
Mumbai	Admin	20
Mumbai	R&D	10
Delhi	HR	40
Delhi	IT	80
Delhi	Finance	50
Delhi	Admin	30
Delhi	R&D	10
Bangalore	HR	25
Bangalore	IT	90
Bangalore	Finance	40
Bangalore	Admin	20
Bangalore	R&D	15
Hyderabad	HR	30
Hyderabad	IT	70
Hyderabad	Finance	30
Hyderabad	Admin	10
Hyderabad	R&D	12
Chennai	HR	25
Chennai	IT	30
Chennai	Finance	20
Chennai	Admin	15
Chennai	R&D	10

However, I require the same format which matrix visual have in Power BI as below:

Location / Department	HR	IT	Finance	Admin	R&D
Mumbai	50	100	60	20	10
Delhi	40	80	50	30	10
Bangalore	25	90	40	20	15
Hyderabad	30	70	30	10	12
Chennai	25	30	20	15	10

Please help me to get this result.

Re: Power BI Export Matrix/Pivot table in Table Form instead same visual form

Anonymous — Thu, 30 Sep 2021 02:25:09 GMT

Hi @Seemaa ,

The exported data won't preserve the formatting in Excel when export the data of matrix visual. Please find the details in the following official documentation:

Export the data that was used to create a visualization

You can use some of the following methods as a workaround:

1. Use the exported data to create a PowerPivot table in the excel file to recreate the matrix visual in Power BI

2. Export reports to PDF from Power BI Desktop

3. Integrating Power BI Tiles into Office documents

In Power BI Service:

4. Copy a visual as an image to your clipboard

In addition, there is one request with similar needs have been posted in the Idea forum. This feature is expected to be implemented in the future, please check the links below for details.

Allow Table and Matrix Data Exports to Match PowerBI Visual

Export to Excel improvements for table and matrix visuals

Best Regards