Show reports in power bi for problem list

chandan1994 · ‎08-03-2020

Hello Team,

i have a requirement to show the report in power bi from servicenow problem table, please how to do this.

should i do power bi integration , if yes please provide the steps too as i am new to integration.

Thanks in advance.

Raks · ‎08-04-2020

I guess there some issue with the URL you are using:

Go to REST APi explorer and in there below the Prepare request option select the problem table from the drop down.

Click on the send button you will get a correct url for the request .

replace the url in code with the one you will get in the REST API explorer.

Remeber to change this part only.

https://<host>.com/api/now/table/problem

chandan1994 · ‎08-07-2020

Hello Aldrin,

you are not doing any changes in servicenow ?

only you have created a user in servicenow and this api you are passing in power Bi ?

Aldrin Panelo · ‎08-07-2020

yes i am not changing anything in servicenow. our servicenow support team created us a service account then they provide read access to REST API

Raks · ‎08-07-2020

Can you please share the exact error that is received.?

Aldrin Panelo · ‎08-07-2020

The error is "We couldn't authenticate with the credentials provided. Please try again"

That is always the error I get even I entered the username and password accurately.

Rajat15 · ‎04-18-2022

Hi ,

How does it work with Scripted REST APIs instead of REST API explorer.