Forum Discussion

Raj007's avatar
Raj007
Helper III
4 years ago

export from pivot table into excel - does not keep the format

Hi All,

This might be a known issue. We are using 2.81 version of PBI report server. When we export the pivot table data into excel
we do not see the same layout as we see it in the Power BI pivot table.. for ex:

Dept    Name             #Emps
IT          IT1                1
             IT2               1
             IT3               1
FIN        F1                    1

              F2                    1

              F3                     1

In Pivot table the Dept name is shown only once but when we export into excel the Dept name gets repeated for each row
is this something we can add it to the expected/wish list - keep the pivot table format/layout as is when exported into excel

1 Reply