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 · Accepted solution]

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)

[Maria20]

Hello Jon,

That did the trick.  I created a custom role and added access control to the change table (i.e. change_request) with the read operation instead of the report_view.

We do not have the ITSM Roles plug-in so this was a successful alternative.  Thank-you!