Power Automate creating a report from a Power BI data model – including header or additional information

This article explains how to create a flow in Power Automate that generates a report by combining data from Power BI (or any other table) with additional information, such as a custom header.

Steps to Create the Flow

Retrieving the Data

You need to retrieve data from Power BI. This can be done easily by clicking through, see this article.

Converting to HTML

Once you have the data, convert it into an HTML table. This format makes it easy to style and enhance the report as needed.

Merging the Header and Data from Power BI

While the data alone could be used as a report, it’s often useful to include additional elements like a header, footer, or summary.
The Compose action in Power Automate is ideal for this purpose, allowing you to:

• Insert custom HTML code
• Use Power Automate expressions and functions

Here’s an example of how you can create a simple header:

Result

The result can be sent in the email body, for example, like this:

Sending as an Attachment

You can also create an HTML file:

convert it to PDF, and send it as an attachment: