Data is missing in Power bi report but exist in Jira.

[BhanuPBI]

Hi Team,

Can any one help me to figure out what is the issue in Power bi reports is showing some missing data but existing in data source. Actually i woked on creating the reports in power bi using jira tempo api i created each employee worklogs and their spend hour in issues. actually for some of the employes data is missing. 

For example: if two Employees A, B is having daily task on Issue A if he submitted work and spend time and he submitted on certain days like 1st feb, 2nd feb, 3rd fed... only one date it is missing. like Employee A spend time 1st it is missing and from 2nd and 3rd it is coming. and Employee B spend time 2nd it is missing and 1st and 3rd it is coming. for your reference i have send you screen shot below with marked missing places. please let me know and how can i figure it out why this issue is comming 

[TomMartens]

Hey @BhanuPBI ,

please be aware that I have no idea about Jira, this means that the following is only "guess work".

I recommend that you check the returned JSON, maybe there is a nested document that needs some extra transformation.

Hopefully, this provides an idea of how to tackle your challenge.

Regards,

Tom