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.
I have connected to our ServiceNow instance by using the ServiceNow content pack in Power BI.
Number of open incidents:
- In the ServiceNow Incident Dashboard I get 6032 open incidents
- If I create a new measure within the data and do a 'COUNT(open_incidents[number])', I get 6385 open incidents
- When I compare to actual number of open incidents within the service now application, I get 6500 open incidents (Status: Open, Assigned, Work in Progress, Awaiting)
Other data fields:
- Data fields opened_at and opened_at_date are not listed at all incidents
- Incident Age group have blank values, even though the incident is within one of the groups.
- I think you have done a count on the incident age group to get number of open incidents, since I then get 6032 as above.
I have big problems trusting the information in this contect pack. Is it only me that receive errors like this in the data?
Where can I see which filters you use in your measures in this content pack, and which filters you use when you retreive data from ServiceNow?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.