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

Tushar Hirpurk1 · ‎08-04-2020

Hi Chandan,

You can connect to ServiceNow data from PowerBI Side by setting up the ODBC Connection.

find below link hope this helps:-

https://www.cdata.com/kb/tech/servicenow-odbc-power-bi.rst

Please mark reply as Correct/Helpful, if applicable. Thanks!

Regards,

Tushar

chandan1994 · ‎08-04-2020

Hello Tushar,

cdata licence will cost some amount, hence please advice if any other work arround

Anna Odrynska · ‎05-20-2022

Hello @chandan1994 ,

I see that you've already accepted the answer, but in case you're still interested in ServiceNow Power BI integration, feel free to check out our new app - Power BI Connector. I'll be happy if it will somehow be helpful to you.

Cheers,

Anna | Alpha Serve