Forum Discussion
Data From Jira have different type in Power Bi
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!
6 Replies
v-yingjlCommunity Support
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 LiHello 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