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

View solution in original post

Aldrin Panelo · ‎08-07-2020

I tried this approach but it's asking me for credentials. I tried basic authentication but I'm getting an error even entering a correct credentials.

I've also tried connecting via Web Data source and im also getting an error when using basic authentication but when I add a Cookie header, it works. but the problem with cookies is it's changing every time so this is not an automated solution, can you help me on this? Thanks in advance!

Raks · ‎08-07-2020

Do you have acecss to REST API ? Are you using the org credetials or basic.

Becasue you need separate access to REST apis in order to extract data from servicenow.

Which is basic access so it is not same as your org account.

Aldrin Panelo · ‎08-07-2020

Yes I also have access to REST API Explorer and we also have a service account that has the necessary REST API Access. I can run API queries in a browser and get the result using that service account.

chandan1994 · ‎08-07-2020

Hello Aldrin,

Can you tell me REST API you have created in servicenow.

Aldrin Panelo · ‎08-07-2020

Hi Chandan,

I am just trying a simple query to test the connectivity.

https://<host>.service-now.com/api/now/table/incident?sysparm_limit=10

when I tried Raks's i didnt change his query, only the hostname.