Power BI Power Query how to increase 1000 row limit to 10,000

[Elizabeth Tachj]

Hi,

How do I increase GET limit to 10,000.

Logged in using basic login.

I have used paginated code, but can only get 1000 row

I used the below with no luck. 

api/now/table/incident?sysparm_offset=10000

api/now/table/incident?sysparm_display_value=all&sysparm_limit=10000&sysparm_offset=4000"))

api/now/table/incident?sysparm_display_value=all&sysparm_limit=5000

When I try all of the above with 1000 row limit the GET works

I changed the time limit in the web connect of power BI connect, that did not work.  It feels like I am restricted to 1000 rows which can be a painful exercise when there are 10,000 rows per month.

Thanks in advance.

[Adam Stout]

These should be set by your system admin: https://docs.servicenow.com/csh?version=latest&topicname=c_ExportLimits

[Elizabeth Tachj · Accepted solution]

Hi Adam.

I ended up working out why the error. The timeout setting in servicenow had to be increased from 1 minute to 5 minutes.  

Cheers

Elizabeth Tachjian

[Elizabeth Tachj]

I will let you know how I go once admin has had a chance to check. Cheers 

E

[Khrystyna Shpar]

Hi Elizabeth, 

If you ever come to considering alternative options to integrate Service Now and Power BI, feel free the try our newest app - Power BI Connector, it is available from ServiceNow Store.

Khrystyna