Versions Compared

Old Version 30

changes.mady.by.user theCode4

Saved on

compared with

New Version Current

changes.mady.by.user theCode4

Saved on

Key

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

Remember that only Jira admins have permanent permission to create data sources. If you're a User, ensure you've received the necessary permissions from your Jira administrator before attempting to create a data source. For detailed instructions on how to set up permissions, please visit the Administration page.

...

To create a Microsoft Power BI Data Source in our app, follow these steps:

  1. Open Data Processor for Jira: Navigate to the app within your Jira Cloud instance.

    navigation to app.jpgImage Removed01_navigation_to_app_violet_no_arrows.jpgImage Added

  2. Go to Data Sources ‘Data Sources’ ➡️ ‘Microsoft Power BIBI’: Select the ‘Data Sources Sources’ section in the left-side menu, and then choose ‘Microsoft Power BIBI’ from the list.

    left bar_data source_power bi.jpgImage Removed02_data_sources_power_bi.pngImage Added

    or

    On the Home page of the main interface, click the 'Microsoft Power BI' icon.

    home_power bi.jpgImage Removed03_home_power_bi.pngImage Added

  3. Create New Data Source: Click on 'Create your first Data Source' in the center of the screen if no Data Sources exist yet.

    create first data source_orange.jpgImage Removed04_create_first_data_source.pngImage Added


    If you've previously created Data Sources, select '+New Data Source' at the top right corner of the screen.

    add new data source button_power bi.jpgImage Removed

  4. Enter Main Information: Fill in the Name and optionally, a description for the Data Source. Click 'Next step'.

    main information_orange.jpgImage Removed

  5. Apply JQL Filter (Optional): Use JQL to filter your Jira data, if needed. Click 'Next step'.

    JQL_orange.jpgImage Removed
  6. 05_add_new_data_source_button_violet_no_arrows.jpgImage Added

  7. Select Tables and Fields: Choose the specific tables and fields you want to include in your Data Source.

    Available tables for export
    In the left right section of the main interface, under each tab of Jira services, you'll find a list of all available tables for export. You can conveniently select the specific tables you need by clicking the 'Plus' (aura-inline- button summaryparamsJTdCJTIybGFiZWwlMjIlM0ElMjIlMjIlMkMlMjJzaXplJTIyJTNBJTIyc21hbGwlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMmNpcmN1bGFyJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJwbHVzJTIyJTdEJTdE) button next to each table. This feature allows for a tailored and efficient export process, ensuring that you export only the necessary data.

    available tables for export_orange.jpgImage Removed

    Additionally, you can easily navigate using the Search bar.

    04_create_first_data_source.pngImage Added


    You can expand the tables to view the available fields and their formats, allowing for a clear understanding of the data structure before exporting.

    expand tables.jpgImage Removed09_expand_tables_violet_no_arrows.jpgImage Added

    The complete list of tables and fields that are available for export can be seen here.
    Selected tables for export
    Clicking the 'Plus' ( Aura inline buttonsummaryparamsJTdCJTIybGFiZWwlMjIlM0ElMjIlMjIlMkMlMjJzaXplJTIyJTNBJTIyc21hbGwlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMmNpcmN1bGFyJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTdEJTdEJTdEJTJDJTIyaWNvbiUyMiUzQSU3QiUyMnBvc2l0aW9uJTIyJTNBJTIybGVmdCUyMiUyQyUyMmljb24lMjIlM0ElMjJwbHVzJTIyJTdEJTdE)

Info

While selecting data for export, you may notice 'Star' badges (stars_pro.pngImage Added stars_xray.pngImage Added) near the name of some tables.

image-20240521-103021.pngImage Addedimage-20240521-102939.pngImage Added

These indicate that the table is available for export only with specific paid add-ons, such as Data Processor for Jira. PRO or Data Processor for Xray. You can find more information about these add-ons in the Apps section or on the Marketplace.

Apps_section.pngImage Added

Selected tables for export
Clicking the 'Plus' button moves tables from the

...

right section to the 'Selected tables for export' section on the

...

left.

...

Here, you

...

can select the fields for export. Check the box next to a label to select all fields within it, or expand the label to choose individual fields. The count of selected fields versus the total available is displayed next to each label name.

...

You can also easily navigate using the Search bar.

...

To remove a table from those selected for export, simply click the ‘Trash bin’

...

button on the right. This will automatically move the table back to the 'Available tables for export' section, allowing you to adjust your selections as needed.

...

09_bin_button.pngImage Added

Info

While selecting data for export, you may encounter the 'As Complex type' switch. Activating this allows you to export data in ComplexTypes, a feature in OData.
ComplexTypes are useful for encapsulating more detailed data types within entity properties. They have properties similar to Entities, and the interface for managing these properties is designed to be user-friendly, mirroring the approach used for Entities. This feature enhances the richness and structure of the exported data.

...

12_complex_type_violet_no_arrows.jpgImage Added

Here is an example of disabled and enabled Complex type for Issue Effort:

...

Save Your Data Source: After selecting all the Tables and Fields you want to export, finalize your settings by clicking the ‘Save+’ button. This action will save the configurations you've made for your data export.

...

13_complex_type_example_issue effort.jpgImage Added


Once all data has been selected, click 'Next Step' to proceed.

...

Note

To activate the ‘Next Step’button and successfully create a data source, you must select at least one field in the 'Selected tables for export’ section.

  1. Apply JQL Filter (Optional): Use JQL to filter your Jira data, if needed. Click 'Next step'.

    13_jql_next_step.pngImage Added

Info

To learn more about JQL and get assistance with its syntax, please refer to this informative article. It offers valuable insights and guidelines to help you understand and effectively use JQL for your data queries.

  1. Enter Main Information: Fill in the Name and optionally, a description for the Data Source. Click 'Save+'.

    14_main_info_description_save.pngImage Added

  2. List of Created Data Sources: After clicking the 'Save+' button, you will see a list of the created data sources ready for export.

    15_list_of_created_data_sources.pngImage Added

Tip

You're now ready to export your Jira data into Microsoft Power BI. For a comprehensive guide on how to proceed with this process, please refer to the detailed instructions available here.

...

.

Keep in mind that you can navigate between steps using the 'Previous step' and 'Next step' buttons, allowing for easy adjustments at any stage of the process.

Info

To easily return to the Home page, simply click on the Data Processor Logo located at the top left corner. This provides a quick and straightforward way to navigate back to the main screen.

Panel
panelIconId2b50
panelIcon:star:
panelIconText⭐
bgColor#FFEBE6

If you've had the chance to use the Data Processor for Jira - Multi BI Connector and Advanced Exporter app, we'd love to hear your thoughts. 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
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJiYWNrJTIwdG8lMjB0b3AlMjIlMkMlMjJzaXplJTIyJTNBJTIybWVkaXVtJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJjaXJjdWxhciUyMiUyQyUyMnN0YXRlcyUyMiUzQSU3QiUyMmlkbGUlMjIlM0ElN0IlMjJjb2xvcnMlMjIlM0ElN0IlMjJiYWNrZ3JvdW5kJTIyJTNBJTIyJTIzMjY4NGZmJTIyJTJDJTIybGFiZWwlMjIlM0ElMjIlMjNmZmZmZmYlMjIlN0QlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyYXJyb3dzLXVwLXRvLWxpbmUlMjIlN0QlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGdGhlY29kZTQuYXRsYXNzaWFuLm5ldCUyRndpa2klMkZzcGFjZXMlMkZEUEZKJTJGcGFnZXMlMkYyMjYxNDAyJTJGQ3JlYXRlJTJCTWljcm9zb2Z0JTJCUG93ZXIlMkJCSSUyQmRhdGElMkJzb3VyY2UlMjNUby1jcmVhdGUtYS1NaWNyb3NvZnQtUG93ZXItQkktRGF0YS1Tb3VyY2UtaW4tb3VyLWFwcCUyNTJDLWZvbGxvdy10aGVzZS1zdGVwcyUyNTNBJTI1NUJoYXJkQnJlYWslMjU1RCUyMiU3RCU3RA==

Aura inline button
summaryFree App
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlN0QlN0QJTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q=
Aura inline button
summaryBook a Demo
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlN0QlN0Q=
Aura inline button
summaryPRO App
paramsJTdCJTIybGFiZWwlMjIlM0ElMjJQUk8lMjBBcHAlMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyZGF0YWJhc2UlMjIlN0QlMkMlMjJtaW5XaWR0aCUyMiUzQTAlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGbWFya2V0cGxhY2UuYXRsYXNzaWFuLmNvbSUyRmFwcHMlMkYxMjMzNTA0JTJGZGF0YS1wcm9jZXNzb3ItZm9yLWppcmEtbGluay1wb3dlci1iaS1sb29rZXItdGFibGVhdS1wcm8lM0Zob3N0aW5nJTNEY2xvdWQlMjZ0YWIlM0RvdmVydmlldyUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA==

...

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!