Forum Discussion
Exporting Data from Table Visual from PowerBI online to Excel
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}.
You can also use paginated report option
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!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.
Another useful resource
- Power BI Report Builder, Create Paginated Report In Power BI Service, How to create Paginated Report
Did I answer your question? Please mark my post as a solution!
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}.
You can also use paginated report option
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
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?
