Null result set for change table using PowerBI to ServiceNow

Maria20 · ‎03-04-2024

Hello SN Community,

We have been trying to connect PowerBI to ServiceNow using a REST API to specific tables. We followed directions accurately to create a user in ServiceNow called power.now with read permissions to certain tables. However, we are still getting null datasets returned in PowerBI for the change table (change_request). However, when we connect to the CMDB table, we get results in the dataset.

If we use a ServiceNow itil user account to connect to the Change table though, it works like a charm.

I'm thinking that something permission-wise is missing with respect to the power.now user and the change_request table.

Any suggestions?

Jon Durden · ‎03-04-2024

I agree about ITIL being overkill. Can you try changing up your custom role so that it is granting read access rather than report view? Also in regards to the sn_write_change role, apparently that is part of a separate roles plugin that you can install? My organization doesn't have that role either. (You might want to look into installing the plugin and using one of those provided roles, but I would check to make sure you don't run into license issues first)

View solution in original post

Maria20 · ‎03-04-2024

Hello again, AG.

I do not have the sn_write_change role in my instance. Looks like I might be missing the "ITSM Roles plugin"...maybe?

Dr Atul G- LNG · ‎03-04-2024

Hi @Maria20

Yes, it can be the reason. Install that plugin and try.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Maria20 · ‎03-05-2024

Thank-you again, AG!

We do not have the ITSM Roles plug-in but I'm checking with our licensing to find out if we can install it. It will probably work after that so I appreciate the response!

Dr Atul G- LNG · ‎03-05-2024

Thanks Maria for update. A new learning from this issue.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Maria20 · ‎03-04-2024

Hello Jon,

Thanks for the response...

The itil role seems a bit of overkill for just wanted to grant access to read a table, just my opinion.

I have created a custom role and granted the power.now user the following ACL to the change table within that role:

I thought that would be sufficient because it is the same setup I have for the CMDB table (which is returning date correctly). However, it is not working.