Exporting Pivot table in Excel

[Sakshi_ag]

Hi,

I am exporting a pivot table from my published PBIX report but it is getting downloaded as a straight table. Can anyone help regarding this?

[v-xiaoyan-msft · Accepted solution]

Hi@Sakshi_ag，

I'm afraid this is not possible at the moment, when you use the export data feature，you can only export the raw data and not retain the visual format. As a workaround, you can use the Export to PDF or Export to PowerPoint functions.

For more information，you can refer to this：Export reports from Power BI to PDF   Export reports to PowerPoint 

Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner： https://ideas.powerbi.com/ideas/search-ideas/?q=export%20pivot%20table 

Hope it helps.

Best Regards,
Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[Marcox28]

power bi does not currently support this function.
in the ideas section there are various threds about it.
we hope they integrate it as soon as possible!