...
Open Data Processor for Jira: Navigate to the app within your Jira Cloud instance.
Go to ‘Data Sources’ ➡️ ‘Microsoft Power BI’: Select the ‘Data Sources’ section in the left-side menu, and then choose ‘Microsoft Power BI’ from the list.
or
On the Home page of the main interface, click the 'Microsoft Power BI' icon.
Create New Data Source: Click on 'Create your first Data Source' in the center of the screen if no Data Sources exist yet.
If you've previously created Data Sources, select '+New Data Source' at the top right corner of the screen.
Select Tables and Fields: Choose the specific tables and fields you want to include in your Data Source.
Available tables for export
In the 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' button next to each table. This feature allows for a tailored and efficient export process, ensuring that you export only the necessary data. Additionally, you can easily navigate using the Search bar.
Image RemovedImage Added
You can expand the t/imagablestables to view the available fields and their formats, allowing for a clear understanding of the data structure before exporting.
The complete list of tables and fields that are available for export can be seen here.
...
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.
Image Modified
| 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.  Image ModifiedHere is an example of disabled and enabled Complex type for Issue Effort:  Image Modified |
Once all data has been selected, click 'Next Step' to proceed.
...
| Aura inline button |
|---|
| summary | Free App |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJGcmVlJTIwQXBwJTIyJTJDJTIyc2l6ZSUyMiUzQSUyMmxhcmdlJTIyJTJDJTIyc2hhcGUlMjIlM0ElMjJyb3VuZGVkJTIyJTJDJTIyc3RhdGVzJTIyJTNBJTdCJTIyaWRsZSUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMyNjg0ZmYlMjIlMkMlMjJsYWJlbCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiU3RCUyQyUyMnNoYWRvdyUyMiUzQSUyMmUyMDAlMjIlN0QlMkMlMjJob3ZlciUyMiUzQSU3QiUyMmNvbG9ycyUyMiUzQSU3QiUyMmJhY2tncm91bmQlMjIlM0ElMjIlMjMwMDY1ZmYlMjIlN0QlN0QlN0QlMkMlMjJpY29uJTIyJTNBJTdCJTIycG9zaXRpb24lMjIlM0ElMjJsZWZ0JTIyJTJDJTIyaWNvbiUyMiUzQSUyMmNsb3VkJTIyJTdEJTJDJTIybWluV2lkdGglMjIlM0EwJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1hcmtldHBsYWNlLmF0bGFzc2lhbi5jb20lMkZhcHBzJTJGMTIzMzAzNCUyRmRhdGEtcHJvY2Vzc29yLWZvci1qaXJhLW11bHRpLWJpLWNvbm5lY3Rvci1mcmVlJTNGaG9zdGluZyUzRGNsb3VkJTI2dGFiJTNEb3ZlcnZpZXclMjIlMkMlMjJ0YXJnZXQlMjIlM0ElMjJfYmxhbmslMjIlN0QlN0Q= |
|---|
|
| Aura inline button |
|---|
| summary | Book a Demo |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRm1lZXRpbmdzLWV1MS5odWJzcG90LmNvbSUyRnRoZWNvZGU0JTIyJTdEJTdEJTdCJTIybGFiZWwlMjIlM0ElMjJCb29rJTIwYSUyMERlbW8lMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyM2ZmZmZmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzMDAwMDAwJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIybGFwdG9wJTIyJTdEJTJDJTIybGluayUyMiUzQSU3QiUyMnR5cGUlMjIlM0ElMjJsaW5rJTIyJTJDJTIydmFsdWUlMjIlM0ElMjJodHRwcyUzQSUyRiUyRmNhbGVuZGx5LmNvbSUyRnN1cHBvcnQtcXlpJTJGMzBtaW4lMjIlN0QlN0Q= |
|---|
|
| Aura inline button |
|---|
| summary | PRO App |
|---|
| params | JTdCJTIybGFiZWwlMjIlM0ElMjJQUk8lMjBBcHAlMjIlMkMlMjJzaXplJTIyJTNBJTIybGFyZ2UlMjIlMkMlMjJzaGFwZSUyMiUzQSUyMnJvdW5kZWQlMjIlMkMlMjJzdGF0ZXMlMjIlM0ElN0IlMjJpZGxlJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzI2ODRmZiUyMiUyQyUyMmxhYmVsJTIyJTNBJTIyJTIzZmZmZmZmJTIyJTdEJTJDJTIyc2hhZG93JTIyJTNBJTIyZTIwMCUyMiU3RCUyQyUyMmhvdmVyJTIyJTNBJTdCJTIyY29sb3JzJTIyJTNBJTdCJTIyYmFja2dyb3VuZCUyMiUzQSUyMiUyMzAwNjVmZiUyMiU3RCU3RCU3RCUyQyUyMmljb24lMjIlM0ElN0IlMjJwb3NpdGlvbiUyMiUzQSUyMmxlZnQlMjIlMkMlMjJpY29uJTIyJTNBJTIyZGF0YWJhc2UlMjIlN0QlMkMlMjJtaW5XaWR0aCUyMiUzQTAlMkMlMjJsaW5rJTIyJTNBJTdCJTIydHlwZSUyMiUzQSUyMmxpbmslMjIlMkMlMjJ2YWx1ZSUyMiUzQSUyMmh0dHBzJTNBJTJGJTJGbWFya2V0cGxhY2UuYXRsYXNzaWFuLmNvbSUyRmFwcHMlMkYxMjMzNTA0JTJGZGF0YS1wcm9jZXNzb3ItZm9yLWppcmEtbGluay1wb3dlci1iaS1sb29rZXItdGFibGVhdS1wcm8lM0Zob3N0aW5nJTNEY2xvdWQlMjZ0YWIlM0RvdmVydmlldyUyMiUyQyUyMnRhcmdldCUyMiUzQSUyMl9ibGFuayUyMiU3RCU3RA== |
|---|
|
...