dataflows - importing data from Web API total of records incorrect

[Mabutho_joe]

Hi All,

having issue screating a dataflow, Im importing data from Jira REST API "https://tools.standardbank.co.za/jira/rest/api/2/search?jql=issuetype%20in%20(epic)" query works on Chrome and Power BI Desktop but when creating a dataflow Total is less meaning it doesn't get all records, see below screen prints.

see different total in below screen prints:

Chrome screen Print:

[Mabutho_joe]

[Mabutho_joe]

[v-qiuyu-msft]

Hi @Mabutho_joe, 

Please click on Refresh button when you in the dataflow edit interface. Please check if the credential used for retrieving data in dataflow is the same as in Power BI desktop. 

Best Regards,
Qiuyun Yu 

[Mabutho_joe]

Hi @v-qiuyu-msft 

I've tried click on refresh button and credintials are both same however I'm still getting same issue of less records than it should be.

regards 

M

[v-qiuyu-msft]

Hi @Mabutho_joe, 

I would suggest you create a support ticket to let engineers look into the issue on your side. 

Best Regards,
Qiuyun Yu