Hi, I am trying to connect PowerBI to servicenow API. I am able to connect it successfuly but it loads limited rows only. please suggest how to pass date filter on createddate field in servicenow so that i can get rows only where created date is after a particular date.
The above solution was actually what I was looking for, but for ServiceNow you can also set sysparm_limit to a larger # it defaults to 10,000. You can also pagenate but I'm not sure how well that works with PowerBI.