Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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
Solved! Go to 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.
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.
I was able to find the solution
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.
I don't quite understand your requirement. What do you mean by "The Name is a Multivalued field"?
Best Regards,
Yulia Xu
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
118 | |
75 | |
46 | |
44 | |
34 |
User | Count |
---|---|
179 | |
89 | |
69 | |
47 | |
47 |