Power Automate for Power BI visualization

One of useful Power Platform functionalities is Power Automate. For instance, you can create and invoke automated flows inside Power BI through a Power Automate for Power BI visualization. Visual is available out of the box.

The first step is to add fields from your data model which are supposed to be used in the flow. It isn’t a obligatory step, you can develop a flow without using data from the model.

The next step is to edit the visualization.

You can use a template — at the bottom. In this case we create a flow from scratch. So that, pick New -> Instant cloud flow.

Our flow inserts rows to an Excel file placed on OneDrive every time it is invoked. Thus, we need to create an Excel file comprises a table with following structure.

This table should be formatted as a table.

Add an Add a row into a table step in the flow and fill necessary fields.

Add values from your data model to respective fields.

You can save and apply your flow.

After you return to the main page, you need to remember to apply the flow.

Your flow is good to go. You can adjust a button appearance.

It is the time for a test. I’ve created a Matrix table. Let’s assume that we want to add records concerning Polk county for dates between 1/1/2019 and 7/1/2019.

Once you hit the button, you have new records inserted in the Excel file.

Let’s go further, make possible a report dataset refreshing directly in the report.

Create another Power Automate: a Refresh a dataset visualization

Apply a flow to the visualization.

Format button and invoke.

The dataflow has been refreshed.