Forum Discussion
Transforming Jira Data in Power BI
Hello I have integrated data from Jira into Power BI with a REST-API for Jira Data. Most of the transformations worked well. However, I always get error messages when I want to convert the hours worked on a ticket into a duration. Does somebody has any idea? As you can see in the picture this is the output i get. If i try to transform it, I allways get an error. Thank you
Hi. That is strange. I'm using jira's api and you have some fields with just seconds values to work with without using that one. I don't think that format will convert to duration. You can try replacing some characters to build something like "hh:mm:00" in order to convert to duration like replace "h " with ":" and add "m " with ":00". If you just want to sum numbers in hours split by "h" and then use math to convert minutos to hours and sum them to the other values.
hope that helps,Regards,
1 Reply
- ibarrau
Super User
Hi. That is strange. I'm using jira's api and you have some fields with just seconds values to work with without using that one. I don't think that format will convert to duration. You can try replacing some characters to build something like "hh:mm:00" in order to convert to duration like replace "h " with ":" and add "m " with ":00". If you just want to sum numbers in hours split by "h" and then use math to convert minutos to hours and sum them to the other values.
hope that helps,Regards,