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!
Be the first to comment