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?

[Nic Brough -Adaptavist-]

All issues have workflows associated with them.  If they don't, then you've got quite a broken system.

You probably need to try the integrity checker first.  Not mess with the database.

[Begoña Bonet]

If I launch the integrity checker.... Will the system performance be punished? That is.... it's better to launch this process this nigth or it doesn't matter...

[Begoña Bonet]

I don't think in update the broken issues, only launch a select count(*) to know the problem magnitude.

[Nic Brough -Adaptavist-]

It won't load it any more than an SQL query. And the checker reads first and then says "I found X issues, do you want to fix them?"

[Begoña Bonet]

Ok! Many thanks!

[Begoña Bonet]

I've launched the checker by I recive "Proxy error" message from server. It must be because of the server/proxy configuration. Is there any other way to know how many issues has been affected?