Data Driven subscriptions with Power Automate && Power BI

With #Power_Platform we have the capability to set up an email subscription for receiving an exported #PowerBI report version.

Using #Power_Automate, you can subscribe a list of email addresses, their RLS roles and send them an email with a .pdf attachment.

Let's say we have a report with a security rule applied by Region, we want to export the Power BI report to PDF and send the filtered report containing only the region data to each person on a subscription list.

😊We have the ability to choose a specific report page, bookmarks, apply filters, apply a security RLS rule across data rows before sending the report to the recipients.

This is done so easily by setting up a scheduled automated flow, which performs the following steps:

✔create a scheduled cloud flow ( once a day for example)

✔Get a list item (from SharePoint list, online excel file, etc.)

✔Run the Power BI export action on a loop for each line of the SharePoint list and send an email containing the report