Power BI Blog: Exportable Formatted Data Tables in Power BI Service
23 June 2022
Late May has seen Microsoft announce the long-anticipated public Preview of a “low-code web authoring experience” for exportable formatted data tables. For the first time, you will be able to author a simple formatted table in Power BI Service. This allows you to use Power BI datasets to edit the final output by contrast to the design first, then adopt an approach that Report Builder requires. It can even add styling!! When you export data, the styling is preserved. Furthermore, since a paginated report is created under the covers, the 150,000 Excel and 30,000 csv row limits do not apply.
To initiate, in Data hub view, select More options (…) next to a Dataset -> Create formatted table.
Alternatively, you may click on a dataset, and select ‘As formatted table’, viz.
The new paginated report online editing experience, formatted table, will open. There are several associated panes which can help tailor / build your formatted table.
To create your table, select field names in the Fields pane on the right. This pane gives you a table-and-column based view of the chosen dataset. When you find a column that you wish to add to your table, select the column or drag it into the pane labelled ‘Build’.
The Build pane has other customisation options for you to create a better looking table. To access these options, select the Format tab at the top of the Build pane.
On the File menu, you may save, download or print your report.
On the Export menu, you can choose the file format you prefer:
You’ve just created your first paginated report in the Power BI Service!
Apparently, Microsoft’s plans don’t stop here. The intention is to move forward, providing the ability to create formatted tables from data in Power BI visualisations and datasets with the ability to filter the data, resize columns, control fonts and colours and export whole tables of data to Excel, PDF or PowerPoint.
Watch this space.
Check back next week for more Power BI tips and tricks!
