Multivalued Column values are not fetched via PowerBI for Jira Connector

[JeevanMallya]

I have a Table called Issue Labels in Jira which has Columns "Issue Key", "Issue ID" and "Name".

The Name is a Multivalued field.

On using this Datasource on PowerBI desktop and extracting data, i see only one values against specific Issue Keys even though they are multivalued in Jira.

I am using PowerBI connector on Jira to create Datasource and using the same on PowerBI desktop to extract.

Can you please suggest how to get this Multivalues.

I am using this

let
Source = OData.Feed(Data_Source, null, [Implementation="2.0"]),
Labels_table = Source{[Name="Labels",Signature="table"]}[Data]
in
Labels_table

[Anonymous]

Hello @JeevanMallya,

Would you consider trying an alternative approach? You may connect your Jira on-premise to Power BI with the help of our app - Power BI Connector for Jira: https://marketplace.atlassian.com/apps/1221150/power-bi-connector-for-jira?hosting=cloud&tab=overvie...

With our Power BI Connector you will be able to:

- build reports based on filtering of Jira custom fields and Marketplace apps custom fields
- combine reporting on multiple Jira projects
- use different data sources in single analytics (Jira, CRM, ERP, ITSM, Financial management software, etc)
- create Jira reports in Power BI with built-in Power BI dashboard templates

- scheduled refreshes for actual Jira reporting.

Daria

===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JeevanMallya]

I was able to find the solution

[JeevanMallya]

Columns that stores Multiple values with a seperator like ABC;DFE;GHI.

In my Case there is a column called Labels which stores value = mismatch;match.

SO when i extarct this to PowerBI desktop, i only get one values either mismatch or match.How to get all the values of specific columns.

[Anonymous]

Hi @JeevanMallya 

I don't quite understand your requirement. What do you mean by "The Name is a Multivalued field"?

Best Regards,
Yulia Xu

[JeevanMallya · Accepted solution]

Its a column in DB the allows to add more than one values.

To be more precise , Jira user add more than one value to this field called "Labels". Here in thge case "QMS_NOT_REQUIRED" and "mismatch". It gets saved to Jira DB Column named "Names" in Table "Issue Labels". So when extract this table on to Power BI Desktop using Powerbi for JIra connector, i am able to extarct only single value.

SO the requirement here is how to get all the values.