Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, using the below query I'm no longer able to query 10,000 rows from SNOW. I used to be able to but now to get this to work I need to limit the sysparm_limit to 6,000 which of course misses loads of data from my results. Any idea how to pull ideally all rows... roughly 20,000? Error I receive is that the maximum timeout has been recieved etc.
= Json.Document(Web.Contents("https://mytechsolution.service-now.com/api/now/v1/table/incident?sysparm_limit=10000&sysparm_offset=... LIKENagios^location.countryLIKEUK^ORlocation.countryLIKEFR^ORlocation.countryLIKEIR^ORlocation.countryLIKEIT^location.u_statusLIKEOpen^sys_created_onONLast 24 months@javascript:gs.monthsAgoStart(24)@javascript:gs.endOfThisMonth()&sysparm_fields=parent_incident,made_sla,u_root_cause_code,u_assignment_group_value,u_severity,sys_created_on,u_initial_assignment_group,closed_at,u_opened_by_group,u_aging_bucket,u_age_of_ticket_duration,close_code,reopen_count,location,number,cmdb_ci,priority,u_document_number,u_root_cause_notes,u_workaround_loe_hours,short_description,reassignment_count,caller_id,resolved_at,close_notes,contact_type,sys_mod_count,sys_created_by,u_market,location.country"))
Hello @Mrooney
In case you're still struggling exporting large chunks of data from Servicenow, you might want to try out our Servicenow app: Power BI Connector:
We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.
Thank you.
Regards,
Anton
===
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Mrooney,
To narrow down this issue, could you try connecting to your ServiceNow with Power BI ServiceNow content pack to see if the same issue occurs?
In addition, if the issue persists, I would suggest you create a support ticket on Power BI Support page for better assistance.
Regards
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
148 | |
116 | |
104 | |
89 | |
65 |