Power BI only counts JIRA Time Spent instead of summing

[Kian Pariwar]

I am currently testing Power BI and connection with JIRA worked perfectly. The template is also fine but I would like to customize it.

One of the customization options is to see the sum of time spent on an issue type. Streangely, the filters in Power BI only let me to count the time spent field instead of summing it.

A little bit of googling revealed that that Power BI only support Count function if there is text in the column / or NULLs instead of numbers. And this can only be fixed by editing the data model.

Problem: I do not see the option to edit the datamodel.

Any idea how to fix this?

[Daniel Wester]

Not really. There are issue entities ( https://developer.atlassian.com/static/connect/docs/modules/jira/entity-property.html ) but in general the idea is that you store it in your db.