Note: This feature is still in the process of rolling out globally, and should be available later this week in all regions.
We’re pleased to announce two new actions are available for the Power BI connector in Power Automate. Now, you may easily leverage the Power BI export API for either Power BI reports or paginated reports in your Power Automate workflows. These new actions make it easy for anyone to quickly export their Power BI content in a variety of supported formats and scenarios. Want to have a Power BI report saved to OneDrive every day at noon as a PDF, or have different reports mailed to everyone on your team in different formats? No problem. Have a Power App using the Common Data Service and want to print an invoice from it using paginated reports? You can do that now too!
To get started, you’ll need to ensure you have at least one workspace in your Power BI tenant backed by a dedicated capacity. This capacity can be any of the A, EM or P SKU’s for Power BI reports, or the A4/P1 – A6/P3 SKU’s for paginated reports. You’ll also need to have a Power Automate subscription that provides access to the standard connectors.
After you create the trigger action for your flow, you’ll have the option to choose the action you wish to run. To select the new export actions, do a search for Power BI and you’ll see the new actions listed. We separated these into a distinct action for each report type, as each API provides different capabilities. This should simplify your development efforts greatly. In addition, we’re planning to add several templates to the gallery to help you get started over the next few weeks. If there are specific templates you’re interesting in seeing, make sure to let us know in the blog comments.
We’re excited about the ways this can be leveraged in your own environment, and it is just one of many new integration options we’ll be making available with the Microsoft Power Platform. Look for the official documentation around this feature to be published in the coming days, and to learn more about all the plans the Power BI team has this year, don’t forget to sign-up for the virtual Microsoft Ignite conference that runs from September 22 to the 24th. See you (online) then!