Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Jadegirlify
Helper I
Helper I

Exporting Data from Table Visual from PowerBI online to Excel

Is it possible to export data to excel from a table visual in powerBI service and preserve all the formatting. Or is there any other availble exporting option that will show keep all(maybe some) layout and colors from the visual table?

Also my report user would like to export data from the powerB report visual retaining the default report name as the exported file name. E.g if the name of the report page is named total exployees, the file should be exported with the default file name as total employee. It currently only exports as 'data'.

Lastly, the data is downloaded with "No filter applied" in the bottom row of the exported data. Is it possible to remove that and the report doesn't show "No filter applied" when exported? Thanks 

2 ACCEPTED SOLUTIONS
DallasBaba
Super User
Super User

@Jadegirlify You cannot get the visual formatting in the exported data, but you can retrieve the column layout.
The export option with "underlying data" allows you to get the data in a table-formatted layout.

 

Users can also select the "Data with Current Layout" option to export the data as a CSV file, preserving the column layout. For example, pbxi.{total employees} and cvs.{total employees}.

DallasBaba_0-1717560388402.png

DallasBaba_1-1717560402088.png

 

You can also use paginated report option

DallasBaba_2-1717560556228.png

 

Lastly, it is not possible to block the display of the applied filter in the report. However, users can transform the data within Excel as needed.

Useful Resource

 
If this post is helpful, please mark it as the solution to help others find it easily. Also, if my answers contribute to a solution, show your appreciation by giving it a thumbs up
Thanks
Dallas

View solution in original post

DallasBaba
Super User
Super User

@Jadegirlify Yes, you can create a paginated report from an existing published report and connect the paginated report table to the main report published.

 

As for me, I let my user reformat the data in Excel.

DallasBaba_0-1717607860754.pngDallasBaba_1-1717607875749.png

 

Another useful resource

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

Thanks
Dallas

View solution in original post

3 REPLIES 3
DallasBaba
Super User
Super User

@Jadegirlify Yes, you can create a paginated report from an existing published report and connect the paginated report table to the main report published.

 

As for me, I let my user reformat the data in Excel.

DallasBaba_0-1717607860754.pngDallasBaba_1-1717607875749.png

 

Another useful resource

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

Thanks
Dallas
DallasBaba
Super User
Super User

@Jadegirlify You cannot get the visual formatting in the exported data, but you can retrieve the column layout.
The export option with "underlying data" allows you to get the data in a table-formatted layout.

 

Users can also select the "Data with Current Layout" option to export the data as a CSV file, preserving the column layout. For example, pbxi.{total employees} and cvs.{total employees}.

DallasBaba_0-1717560388402.png

DallasBaba_1-1717560402088.png

 

You can also use paginated report option

DallasBaba_2-1717560556228.png

 

Lastly, it is not possible to block the display of the applied filter in the report. However, users can transform the data within Excel as needed.

Useful Resource

 
If this post is helpful, please mark it as the solution to help others find it easily. Also, if my answers contribute to a solution, show your appreciation by giving it a thumbs up
Thanks
Dallas

@DallasBaba Thanks so much for the feedback. Am I able to create a paginated report from an existing pubished report? Keeping all the filter selections, and not having to build from the scratch?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.