Scheduling Power BI Reports with Inforiver: A step-by-step tutorial
This is the bi-weekly newsletter "Inforiver for Power BI" which showcases how businesses can consolidate their reporting on Power BI and drive returns on their existing investments. Inforiver offers the fastest way to build, visualize, analyze, comment, collaborate, forecast, simulate, write back, and schedule Power BI reports.
Would you like to get notified whenever we post an article on LinkedIn? If so, don't forget to subscribe to this newsletter.
***
It is a common requirement across organizations to schedule Power BI reports periodically, where the report data (exported to Excel/PDF files) need to be sent by email to multiple recipients, or shared folders such as OneDrive, Microsoft Teams, SharePoint and Google Drive.
We’ll quickly explore how you can set this capability using Inforiver for Power BI.
For example, we’ll take up a sales forecast report, which tracks sales performance as of current month (August). This report gets updated regularly, but we would like to schedule this for all our sales reps by email twice a week.
To create a report schedule using Inforiver, go to the Export tab, and click on ‘New Subscription’
If you are not authenticated by Inforiver already, you will be provided with a prompt to sign in with your Office 365 credentials. This is how Inforiver recognizes the user who is creating the schedule.
If you have signed into Office 365 already in your browser, you need not enter your credentials this time. Inforiver will automatically take you to the next step as outlined below.
You will now be taken to a portal which opens in a separate tab and will be asked to choose an Inforiver workspace. Note that these workspaces are created by users with admin rights, who will need to provide you with the rights to access this workspace. This ensures that different workspaces can be created for different teams, business units, and functions in your organization. In our case, we have access to one workspace which we shall select.
You will now be taken to a ‘New Subscription’ screen directly. As you can observe, creating a subscription is a three-step process: (a) select report (b) set subscription frequency, and (c) select destinations
STEP 1: Select Report
In this first step, we need to specify?WHAT?needs to be scheduled. As shown below, there are several options you can configure while choosing the report you want to schedule.
The numbers listed below correspond to the numbers listed in the image above.
1. Enter a name for the subscription schedule
2. Choose which report needs to be scheduled
3. Specify whether the report has Row Level Security (RLS) that needs to be adhered to
4. Choose whether we need the ability to send specific records in the report to specific users (e.g., US records to the US Regional Head, EMEA records to EMEA Regional Manager, etc.). You may use this option if you do not have any RLS defined for your data. This is very helpful for organizations with a small and manageable number of recipients.
5. A Power BI report can have several tabs/pages. In this step, you choose whether you want all pages to be sent. In our case, we are scheduling only one tab named ‘Email Schedule’, and all the other tabs in the report will be ignored by the scheduler.
6. Specify whether you need the dataset to be refreshed prior to each run
7. Dataset owner from whom you need to receive permission
8. Specify whom to notify in case the schedule run fails
9. You have the option to include report metadata at the end of the PDF report. A sample of the last page is shown when you hover on the help icon.
Once you have set up?WHAT?to schedule using the above steps, click on the Next button at the bottom of the page.
STEP 2: Set Schedule Frequency
In this step, we need to provide details of?WHEN?the schedule needs to run.
In our case, we are scheduling the report run at 4 AM Eastern Time every Tuesday and Thursday, till Jan 15th?of the next year.
By default, the start and end dates are the same. Using the default setup will help you do an?ad-hoc, on-demand, one-time email schedule.
领英推荐
Click on the Next button at the bottom of the screen.
STEP 3: Select Destinations
The final step is to mention?WHERE?the report extracts need to be sent/delivered.
Inforiver allows you to schedule Power BI reports to email, OneDrive, Microsoft Teams, SharePoint, and Google Drive. We will look at email and OneDrive options. The remaining options are very similar to the OneDrive setup.
Step 3 a) Schedule Power BI Report to Email
Here you can configure the following:
While choosing email recipients, you can ensure that specific categories are sent to specific reps. In our case, this user receives only the pages corresponding to US Central and US East regions.
Not that the above option is available only when (a) Your report uses category-based page breaks?as part of the?Reports Plus?feature and (b) when we enable ‘Report plus layout’ in Step #1 – ‘Choose Report’.
After you click on ‘Review’ at the top of the screen, you will be shown a review page.
Click on ‘Save Subscription’ to save the email schedule.
Clicking on the saved schedule now gives you more options – such as
Whenever the schedule runs, emails are triggered to recipients. Here is a sample email received from the scheduler (for a different report). Note that it has the Excel and PDF files as attachments and an image embedded within the body of the email. This ensures that users do not have to open file attachments in order to view the report summary.
Step 3 b) Schedule Power BI report to OneDrive, Microsoft Teams, SharePoint, and Google Drive.
The steps for these options are very similar. We will explore how to set it up for OneDrive.
After you set up the email destination, you can select OneDrive from the menu on the left. Note that Inforiver supports scheduling to multiple destinations as part of a single job schedule.
Once you sign in to OneDrive, you can choose the destination folder. Review & and save the subscription once you have provided all the inputs.
Scheduling Power BI reports to Microsoft Teams, SharePoint and Google Drive are very similar.
***
SUMMARY
Overall, we explored the following:
The scheduler is available as part of Inforiver Enterprise. Learn more about the latest updates in Inforiver Scheduler?here .
Have a question on scheduling? Drop us a note at?Inforiver Community , and we will be happy to answer your questions.
Originally published at?https://inforiver.com ?on?Sep 02, 2022.