• Home
  • About Us
  • Contact Us
  • Privacy Policy
  • Special Offers
Business Intelligence Info
  • Business Intelligence
    • BI News and Info
    • Big Data
    • Mobile and Cloud
    • Self-Service BI
  • CRM
    • CRM News and Info
    • InfusionSoft
    • Microsoft Dynamics CRM
    • NetSuite
    • OnContact
    • Salesforce
    • Workbooks
  • Data Mining
    • Pentaho
    • Sisense
    • Tableau
    • TIBCO Spotfire
  • Data Warehousing
    • DWH News and Info
    • IBM DB2
    • Microsoft SQL Server
    • Oracle
    • Teradata
  • Predictive Analytics
    • FICO
    • KNIME
    • Mathematica
    • Matlab
    • Minitab
    • RapidMiner
    • Revolution
    • SAP
    • SAS/SPSS
  • Humor

Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

September 30, 2020   Self-Service BI

This weekend I had the pleasure of presenting at SQL Saturday Copenhagen #963 with a session with the title “Power BI Paginated Reports – How to and why”.

I was asked if it was possible to create datadriven report subscriptions in paginated reports and I said “Not yet” – it turns out that is not exactly true.

With the new action “Export to File for Paginated Reports (preview)” – in Power Automate – link

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

It is possible !!!

And yes, for now we need the reports to be stored in a workspace backed by premium capacity but soon it will be available here

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

How to set it up

In my workspace I have a simple report with 2 parameters – Year and Country

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

In order to get a report delivered to multiple recipients with different parameters I created an Excel Workbook in Onedrive for business with 3 different reports I want sent all with different parameters for County and Year.

You can store the data in other sources that you can connect Power Automate with – but for the example I just used Excel file.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

Next is to design the flow in Power Automate

In the example I choose the trigger “Manually trigger a flow” – but you can of course choose other triggers to activate this flow – for instance a Recurrence so you can execute the reports at a specified frequency.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

Next step is to get the rows from the Excel file – So I use the List rows present in a table

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

This action will return the three rows and next is to use the Control “Apply to each” to loop through each row

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

For the output we choose the value from the “List Row…” step

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

Then we add the action “Export To File for Paginated Reports

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

This action will run a selected report from a specific workspace

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

We can choose between the different file formats that is possible for paginated reports – in this example I chose PDF.

Add the end of the Action window – we can specify the values for each of the parameters.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

OBS – You have to type in the Parameter name manually and be aware that the name of the parameter doesn’t necessarily match the label shown

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

As in this case – the Year parameter is called “DateCalendarYear” – and that is the name you must use for “ParametersValues name”

We bind the value of the parameter to the value from the Excel file using the Dynamic content selector.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

Next step is to add a step to send the report and bind the fields for the To field – add a subject and in the attachments section we give the attachment a name and then use the result of the “Export to File for paginated reports” as the attachment content

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

The flow is now ready for testing – Save you flow and hit the test button.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

Accept the used connections and hit Run Flow and we can go to the flow run overview and follow the steps.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

Hopefully you will see that all steps are successfully.

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

And we can check our mail box to see the report delivered

 Setup data driven report subscriptions for #PowerBI paginated reports with #PowerAutomate

The recipients of the e-mail can be sent to any e-mail address.

Can we pay by the hour ?

In my case I used an Power BI Embedded A4 SKU as capacity – this can be turned on and off so you can expand the flow with actions that can start the capacity and run the subscriptions and then turn the capacity off again.

You only pay for the time the capacity is on – and the list price per hour is $ 8.

Hope this can help you and really looking forward to all exciting stuff that is coming around Power BI paginated reports.

Let’s block ads! (Why?)

Erik Svensen – Blog about Power BI, Power Apps, Power Query

#powerautomate, #powerbi, data, Driven, Paginated, Report, Reports, Setup, subscriptions
  • Recent Posts

    • Switch from Old Record View to Kanban Board View to Maximize Business Productivity within Dynamics 365 CRM / PowerApps
    • PUNNIES
    • Cashierless tech could detect shoplifting, but bias concerns abound
    • Misunderstood Loyalty
    • Pearl with a girl earring
  • Categories

  • Archives

    • January 2021
    • December 2020
    • November 2020
    • October 2020
    • September 2020
    • August 2020
    • July 2020
    • June 2020
    • May 2020
    • April 2020
    • March 2020
    • February 2020
    • January 2020
    • December 2019
    • November 2019
    • October 2019
    • September 2019
    • August 2019
    • July 2019
    • June 2019
    • May 2019
    • April 2019
    • March 2019
    • February 2019
    • January 2019
    • December 2018
    • November 2018
    • October 2018
    • September 2018
    • August 2018
    • July 2018
    • June 2018
    • May 2018
    • April 2018
    • March 2018
    • February 2018
    • January 2018
    • December 2017
    • November 2017
    • October 2017
    • September 2017
    • August 2017
    • July 2017
    • June 2017
    • May 2017
    • April 2017
    • March 2017
    • February 2017
    • January 2017
    • December 2016
    • November 2016
    • October 2016
    • September 2016
    • August 2016
    • July 2016
    • June 2016
    • May 2016
    • April 2016
    • March 2016
    • February 2016
    • January 2016
    • December 2015
    • November 2015
    • October 2015
    • September 2015
    • August 2015
    • July 2015
    • June 2015
    • May 2015
    • April 2015
    • March 2015
    • February 2015
    • January 2015
    • December 2014
    • November 2014
© 2021 Business Intelligence Info
Power BI Training | G Com Solutions Limited