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

[Mahathi]

My only concern is it works for my admin id.

And the same doesn't work with a different user id.

[Mahathi · Accepted solution]

Thankyou everyone for taking out time to respond.

Realized the error was because of the number of rows, when i limit with an additional query. it is fetching the data.

Thankyou again

[Purush2]

I prefer a simple REST account data export through reports. During the defined PBI refresh, servicenow reports refresh providing the required data based on your data requirement.