Data through REST API into power bi

[Raks]

Team,

Need help, I am trying to get Servicenow data into power bi using table API. I am somewhat successful but came to a roadblock as I can only able to extract 4000 records in a single query. Although I have read that there is a default limit of 10000 records a query can fetch.

My idea is to get the 10000 records in power bi using query and then I will use incremental refresh to update the data in my data model.

Any help is highly appreciated.

[Ankur Bawiskar]

Hi,

how many records are there in task table since it would include all child tables as well?

what is the http status code and the error message?

Regards

Ankur

[Ashby0003]

Yes, I've run into this in the past. It's not making it to 10k because of the amount of data which is being exported.  It's hitting a timeout first.

Basically what's happening is you're pulling every field on the task table which is a lot when you think about Problem/Change/etc. I would recommend making a decision on which fields you actually need.

If in fact you need every field or more than 10k records you can loop the Get call multiple times using the  sysparm_offset & sysparm_limit parameter.

[Adam Stout]

There are many reasons not to export your data (i.e., timeliness, security, actionability), but if are, try an export set or a 3rd party tool.

Keeping the data in sync can be a challenge (if any fix script or other processes disable sysAutoFields).  You want to make sure your admins are fully in the loop.

[chandan1994]

Hello Raks,

As you are getting reports in power bi from servicenow, could you please tell me how you did this as i have a similar requirement. 

means how you are passing this query? from where ? and how?

https://xxx.service-now.com/api/now/table/task?sysparm_display_value=true&sysparm_exclude_reference_link=true

Thanks for the help in advance.

this is my question in comunity

https://community.servicenow.com/community?id=community_question&sys_id=b0fd01ebdb52589066f1d9d96896...