Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

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

    02_save.jpg03_name.jpg
  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.

    04_login_service.jpg
  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).

    05_select_workspace.jpg
  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.

    07_open_in_pb_service.jpg
  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.

    08_semantic_schedule_refresh.jpg
  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.

    09_edit_credentials.jpg
  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'.

    10_basic_mail_api.jpg

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

    11_data_applied.jpg
  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.

    12_refresh_settings.jpg

...

Info

For comprehensive instructions on how to set up a scheduled refresh in Power BI, you can visit the official Power BI support page or documentation. They provide in-depth guidance and step-by-step procedures to help you automate your data updates effectively.

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#configure-scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

Panel
panelIconId1f914
panelIcon:thinking:
panelIconText🤔
bgColor#F4F5F7

For those weighing the options between Power BI Report Server and Power BI Service, a helpful comparison article can provide valuable insights. This resource will assist in understanding the differences and advantages of each, aiding in your decision-making process. ⬇️

https://learn.microsoft.com/en-us/power-bi/report-server/compare-report-server-service

Panel
panelIconId2b50
panelIcon:star:
panelIconText
bgColor#FFEBE6

If you've had the chance to use the Data Processor for Jira - Multi BI Connector .Freeand Advanced Exporter app, we'd love to hear your thoughts. Please feel free to share an honest review! Help us improve by sharing your honest review of the Free, PRO or Xray versions. Your feedback is crucial as we strive to improve and tailor our services to better meet your needs. 🤝

...

Aura inline button
summaryback to top
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJiYWNrJTIwdG8lMjB0b3AlMjIlMkMlMjJzaXplJTIyJTNBJTIybWVkaXVtJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZmZmZmYlMjIlN0QlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyYXJyb3dzLXVwLXRvLWxpbmUlMjIlN0QlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGdGhlY29kZTQuYXRsYXNzaWFuLm5ldCUyRndpa2klMkZzcGFjZXMlMkZEUEZKJTJGcGFnZXMlMkYyMjk0MjMxJTJGRXhwb3J0JTJCdG8lMkJNaWNyb3NvZnQlMkJQb3dlciUyQkJJJTIzRXhwb3J0LUppcmEtZGF0YS10by1NaWNyb3NvZnQtUG93ZXItQkktRGVza3RvcCUyMiU3RCU3RA==JTdCJTIybGFiZWwlMjIlM0ElMjJiYWNrJTIwdG8lMjB0b3AlMjIlMkMlMjJzaXplJTIyJTNBJTIybWVkaXVtJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZmZmZmYlMjIlN0QlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyYXJyb3dzLXVwLXRvLWxpbmUlMjIlN0QlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGdGhlY29kZTQuYXRsYXNzaWFuLm5ldCUyRndpa2klMkZzcGFjZXMlMkZEUEZKJTJGcGFnZXMlMkY4MjkwMzM0JTJGU2V0dGluZyUyQlVwJTJCU2NoZWR1bGVkJTJCUmVmcmVzaCUyQmluJTJCTWljcm9zb2Z0JTJCUG93ZXIlMkJCSSUyM1NldHRpbmctVXAtU2NoZWR1bGVkLVJlZnJlc2gtaW4tTWljcm9zb2Z0LVBvd2VyLUJJLVNlcnZpY2UlMjU1QmhhcmRCcmVhayUyNTVEJTIyJTdEJTdE

Aura inline button
summaryFree App
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q=
Aura inline button
summaryBook a Demo
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlN0QlN0Q=
Aura inline button
summaryPRO App
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q=JTdCJTIybGFiZWwlMjIlM0ElMjJQUk8lMjBBcHAlMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyZGF0YWJhc2UlMjIlN0QlMkMlMjJtaW5XaWR0aCUyMiUzQTAlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGbWFya2V0cGxhY2UuYXRsYXNzaWFuLmNvbSUyRmFwcHMlMkYxMjMzNTA0JTJGZGF0YS1wcm9jZXNzb3ItZm9yLWppcmEtbGluay1wb3dlci1iaS1sb29rZXItdGFibGVhdS1wcm8lM0Zob3N0aW5nJTNEY2xvdWQlMjZ0YWIlM0RvdmVydmlldyUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA==

...

Panel
panelIconId1f917
panelIcon:hugging:
panelIconText🤗
bgColor#E6FCFF

Still have questions? Feel free to reach out to us for any additional information or to request new features!