Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I have a api from Service Now to pull data to Power BI. All the fields are pulling from Service Now, however, one column for a field is blank.
in Service Now the field is a drop down with values assigned to the text. Example value 13 = "Closed No CPNI Breach". However, when imported the field is there <u_State> but the field in Power BI is blank. I would expect it to show value 13.
The link to the data shows:
<u_state/>
I would expect it to show <u_state/>13<u_state/>
This is a portion of the code of what it should look like:
Solved! Go to Solution.
I was able to figure out the issue. It was not between SN and PBi
I was able to figure out the issue. It was not between SN and PBi
Hi @Anonymous ,
Unfortunately, I don't have Service Now...Hope this thread can help you:
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 3 | |
| 3 | |
| 2 | |
| 1 | |
| 1 |