Data From Jira have different type in Power Bi

[Anonymous]

Hello everyone,

I have a problem with data downloaded from Jira to Power Bi. In the Jira page, in a custom field "Teams" all data are string type, ex. Team Alpha, Team Bravo etc.

However, when i connect to Jira in Power Bi, these data transform to some numbers. For example, "Team Bravo" changes into 55 in all rows, and "Team Alpha" changes into 78. What is more, other custom fields (no matter if they are string or integer), doesn't change, and their value is the same as in the Jira Page.

Do you have any ideas, what can be the reason?

Thank you!

[v-yingjl]

Hi @Anonymous ,

Based on your description, not certain which reason causes this issue. Could you please consider sharing some screenshots or a dummy sample file for further discussion?

Best Regards,
Yingjie Li

[Anonymous]

Hello @v-yingjl, Yes sure! I will give you a short description what is included in the screenshots below. 

On the first one, there is how the data downloaded from Jira, looks like in Power Query. The second screenshot, shows the custom field "Team" in Jira, with some options to choose. So as you can see, despite the fact that in Jira these data has values like "Team 1" etc, in Power Query it changes to some numeric values.

Thanks for your help!

  

[v-yingjl]

Hi @Anonymous ,

Have you tranformed data like combine columns, changed data type etc. in power query when connectting to Jira?

Could you please consider sharing the applied steps in the right side of power query like this?

Best Regards,
Yingjie Li

[Anonymous]

Hello @v-yingjl 

I have figured out what is the problem, but i dont have any idea how to solve it.

This field "Team" in Jira, is a part of Shared teams and people, and jira automatically assign to it an ID. For example, when i write in JQL filter a statement "Team = Team Bravo", Jira transform it to "team = 13".

Do you have any idea, what i can do with it?

[v-yingjl]

Hi @Anonymous ,

I found a note like this in Jira's document but not certain whether it could explain this phenomenon accurately because I’m not very familiar with jira, hopes it could be helpful:

When you apply the filter, you are also creating a Transformation. The Transformations button is highlighted, showing that a transformation has been applied.

Here are the related documents:

1. Filter Is a Transformation 
2. Using Transformations 

Best Regards,
Yingjie Li

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

[Anonymous]

Hello @v-yingjl ,

No, i didnt transform any columns in the query steps. Previous steps, are for example, list combine, list generate, list transform.

Here is a screenshot of previous steps in query. I'm wondering, why others string columns didnt transform into some random numeric values, but the column "Team" transformed.

Best Regards