Power BI Web API user access

[Mahathi]

Hello all,

I am trying to use Web API option in Power BI to fetch data from ServiceNow.

I have given all the access roles - Like rest api explorer, Web services admin including incident/table specific ACL roles.

I am only seeing a null/empty row in PowerBI when connected.

But when i impersonate the user in ServiceNow i am able to see all the records from tables.

Not sure what i am missing.. Any leads to this?

Thanks,

Mahathi

[Marcos Kassak]

Hi @Mahathi,

Which API are you using? Is it Table API? If so, can you share more details so we can troubleshoot together?

Thank you

[Mahathi]

Hi Marcos,

Yes i am using table API https://my servicenow instance name/api/now/table/incident

i am trying to access this from Power BI with the user having itil + webservice+rest api roles, the rows are null.

And it works well with my admin id.

Thanks!

[Sohail Khilji]

Any specific errors ?

[Mahathi]

No errors as such.

The data is displayed as null there, it is getting connected to my instance though but fetching null rows.