March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
First off, if anybody knows of any pre-built ServiceNow incident and SLA reports I can use to get me started, I'm all ears. I see some posts from 2016 where MS seemed to have something available, but it's nowhere to be found now. On to my questions...
I'm grabbing data from the ServiceNow table API. It's expanding the json to records and in the end I get a bunch of columns but they're all named result.x and not just x. I've tried looking at the M code and changing "result" to "incident" or just using empty quotes but it throws errors when I apply and close power query editor. I'm not seeing settings in the GUI for any of the query steps.
I just want a table called "incident" and the columns to just have the name that SN returns like "State", "Priority", not "result.priority", "result.state", it's confusing and manually updating all by hand seems like the wrong way to go.
When it comes to modeling the data the, is it not possible to have multiple relationships from 1 table to another?
For example my incident table has 4 fields that are references to the user table and contain the user's primary key (but not the same user, fields are things like "caller" and "assigned_to". I want to relate those all to the user primary key on the user table. But don't seem to be able to do that. I tried unpivoting those cols and that sort of works from a data model perspective but I'm not able to get anything plotted in a useful way.
I also tried just looking up the user name by key and adding those as new cols but looking up values from another table doens't seem to be supported behavior. I must be approaching this issue all wrong. My goal is to be able to plot or filter incidents by user and user's department fo the "caller" field, or the "assigned to" field on the incident record (and those fields only contain a user's PK value so not useful as-is).
I've attached a screen shot which illustrate both the "result.x" issue, note that all of these have it which come from the API source, and the model challenges I'm having related to resolving a name from a key.
Thanks for anyone who has some tips. I've done a fair amout of analysis work in R from previous life in some comp bio work but am just starting in PBI.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
134 | |
91 | |
89 | |
64 | |
58 |
User | Count |
---|---|
201 | |
137 | |
107 | |
72 | |
68 |