Learn how to use the Power Automate 'Export To File for Power BI Reports' action to generate a PowerPoint presentation output of your Power BI reports.

In this video, I'll talk you through the steps required to create your own customised Power BI subscriptions.

I'll explain how to use Power Automate to generate a PowerPoint file with the pages you choose and the filters you require. I'll then explain how to set up a system that attaches the PowerPoint report to an email and automatically sends this email every week (or whenever you choose!)

Note: You need to have a Premium per/capacity license to be able to use the Export To File for Power BI Report actions in Power Automate.

Tip: This is a longer video so why not try increasing the playback speed to save time. Research has shown that this can speed up your learning! You'd be surprised how well it works!


⏩ Video Navigation

00:44 Overview of business requirements
03:00 Limitation of current out the box options in Power BI service
04:16 Licence Limitations
05:06 Overview of Power Automate Steps
06:21 Department email address mapping
07:06 Setting up the Power Automate Schedule cloud Flow
07:58 Connecting to Excel date from Power Automate
09:30 Setting up 'Export To File for Power BI Reports' action
10:25 Report level filters in 'Export To File for Power BI Reports'
13:05 Specifying the Power BI PageNames to include in your PowerPoint report
17:07 Specifying Bookmarks to apply to pages that are exported to PowerPoint
18:33 Creating an email and attaching the PowerPoint file created
21:53 Testing the parameters exported to 'Export To File for Power BI Reports' actions
25:54 Confirming test was successful


Power BI Dashboard Training

FREE Power BI Quick Start Course Learn how to create your first dashboard in around 90 minutes!
https://effectivedashboards.com/power...

Power BI Quick Start PLUS Learn how to craft KPI management dashboards that really do help you, your boss, and your peers make better decisions!
https://effectivedashboards.com/power...


Resources

Access to the source PBIX files for my YouTube videos:
https://effectivedashboards.com/cours...

Article series on creating a maintenance management system data model and how to address the human factors of data collection for improved data quality. (This is not just relevant to maintenance and reliability data).
https://effectivedashboards.com/data...

Adding filter parameters to Power BI service URLs
https://docs.microsoft.com/enus/powe...