Null result set for change table using PowerBI to ServiceNow

[Maria20]

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]

Out of box, an ITIL role is required for read access to the change request table. I'm guessing that your power.now user does not have access to ITIL. There are a few approaches you could take, but one is you might consider creating a custom read ACL role on the change table and assigning that to your power user.

[Dr Atul G- LNG]

Minimum role is not ITIL, is sn_write_change role.  ITIL will a more access of tables.

[Maria20]

Hello AG,

Thanks for the response.  Unfortunately, I cannot locate the sn_write_change role that you reference...

[Dr Atul G- LNG]

Hi @Maria20 

Sorry,