

Duplicates cannot be removed as there is data in other rows which is required. When I tried to extract values, it gives me error so I have to expand it to new rows which create duplicates in column - 'key'. Most of the projects are using fix versions and versions field where few projects are using other 4 fields.Īs you can see all these 6 columns are list or records. Release Information.įor all JIRA projects in my report, I derived that following 6 fields are used (shown in screenshot).

The only problem here is one field which is not used in a harmonized way for across all JIRA projects and i.e. I am working on Power BI project where I am fetching data from many JIRA projects.
