How to download data from a table visual without missing format of the table?

[SantoshG45]

Hi,

I have a requirement, when export data from the Power BI table visual in to Excel, format is missing in the excel sheet. To accomplish this task by using create export table option, but unable to sync slicers with the report. In paginated report i used the format table but slicers on the power bi page is not able to sync and no option found. 

My requirement is when export data from the table visual same format is export to Excel. Pagniated reports i used here Paginated report and Table visual is show the same data after apply the slicers. Please help me to acheive this.

[SantoshG45]

Hi @v-luwang-msft 

I tried the same way that you are explain above but in not in desktop version need in Power BI online, when i export data by using either Summerized data option or current Layout option some formatting options are missing which we do in Power BI transformations like new line spacing and paragraph alignment are missing. 

[v-luwang-msft]

Hi @SantoshG45 ，

Test like the below，the followiing is a report, choose export data :

Then :

Final open excel:

refer:

https://powerbi.microsoft.com/en-us/blog/enhanced-decision-making-with-connected-pivottables-and-imp...

Did I answer your question? Mark my post as a solution!

Best Regards

Lucien