Using the standard features of Power BI, data extracted through the Data Processor for Jira can be configured for automated refreshes on a scheduled basis, either in the Power BI Report Server or the Power BI Service.

Setting Up Scheduled Refresh in Microsoft Power BI Service

To set up a scheduled refresh in Microsoft Power BI Service, follow these steps:

1. Once you have exported a data source into Power BI Desktop, click the 'Publish' button located on the upper toolbar, or alternatively, navigate through File ➡️ Publish ➡️ Publish to Power BI.
   

   

2. If you haven't done so already, save your report by assigning it a name and selecting the desired save location.
   

   

3. If you weren't logged in previously, the next step is to sign in to your Microsoft account. This is necessary to proceed with the publishing process in Power BI Service.
   

   

4. Next, choose the workspace in Power BI Service where you wish to publish your report or dashboard, then click 'Select' (unlike creating a dataflow directly in Power BI Service, here you have the flexibility to choose 'My workspace' as an option for publishing).
   

   

5. Once the publishing process is complete, you can review your report either by clicking on the provided link or by directly accessing your Power BI Service. This allows you to immediately see and assess the published report or dashboard in the selected workspace.
   

   

6. In Power BI Service, locate the recently published semantic model (previously known as 'Dataset'). Then, to manage its data refresh schedule, click on the 'Schedule refresh' button.
   

   

7. If a warning appears stating ‘Failed to test the connection to your data source’ in the next dialog, you should click on 'Edit credentials'. This will allow you to adjust or update your connection settings to ensure a successful data source connection in Power BI Service.
   

   

8. Choose the 'Basic' authentication method and proceed to enter your credentials. Use the email associated with your Jira Cloud instance for the user name field, and your Jira API Token as the password (for guidance on obtaining your Jira API token, please refer to this page). Click 'Sign in'.
   

   

   Upon successful setup, you should see a confirmation in the pop-up window:
   

   

9. Scroll down to the 'Refresh' tab. Here, enable data refresh by selecting ‘On’. You can then choose the frequency of the refresh, set the time zone, and specify the exact time for the refresh to occur. Additionally, there's an option to designate a contact for refresh failure notifications. After configuring these settings, make sure to click 'Apply' to save the changes. This completes the process of setting up scheduled data refreshes for your semantic model.
   

   

Setting Up Scheduled Refresh in Microsoft Power BI Report Server

To set up a scheduled refresh in Microsoft Power BI Report Server, follow these steps:

1. After exporting a data source into Power BI Desktop for Report Server, which follows the same procedure as a normal Power BI Desktop export, go to File ➡️ Save as ➡️ Power BI Report Server to save your report.
   

   

2. In the pop-up window, select either the most recent Power BI Report Server from the list or provide the URL for a new one.
   

   

3. Assign a name to your report and confirm by clicking 'OK' to save it.
   

   

4. Once the saving process is complete, you can review your report either by clicking on the provided link or by directly accessing your Power BI Report Server.
   

   

5. In Power BI Report Server, navigate to the 'Browse' section. There, locate your report, click on the settings button (represented by three dots) next to it, and select 'Manage'.
   

   

6. In the subsequent dialog within the Power BI Report Server, navigate to 'Scheduled refresh' located in the left sidebar. From there, proceed by clicking on '+New scheduled refresh plan'.
   

   

7. Provide a brief description of your scheduled refresh plan and select 'Edit schedule' to configure the specific settings for your refresh plan. This step is vital to tailor the automatic refresh intervals according to your report's requirements.
   

   

8. Set your desired refresh frequency (hourly, daily, etc.), and specify the time/period for the refresh to occur. Then, define the start date and, if needed, an end date for the schedule. To finalize your settings, click 'Apply'.
   

   

9. To complete the setup of your scheduled refresh plan in the Power BI Report Server, simply click on 'Create scheduled refresh plan'. This action will finalize and activate the plan.