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

[Sohail Khilji]

Possible to share a screenshot ?

[Mahathi]

[Sohail Khilji]

Hi @Mahathi ,

I can see the issue is with the user role. which role does the user have ? 

[Mahathi]

web service admin, rest api explorer, itil.. now tried giving even admin

[Sohail Khilji]

Some ways that you can try is :

1. See if the incident table has any restriction on who can read write data.

2. Try to connect via ( PostMan ) see if you can get the data. if yes then all the access are clear. issue must be on PowerBI

happy to help further