How can I connect a ServiceNow report to a Power Bi Dataflow?

[IoanaU]

Hi everyone

I hope I'm in the right forum - a complete ServiceNow newbie here.

So, I have created a report in ServiceNow. I'd like to connect a PowerBi Dataflow to it so I can bring in the data within.

Now, ChatGBT says that is not possible, BUT I can connect to a table.

ServiceNow provides an OData API, which allows you to access ServiceNow data directly in a Power BI dataflow. You can use this API to pull data from ServiceNow into your dataflow.

Steps:

1. Get OData URL from ServiceNow:

   • In ServiceNow, configure the OData endpoint. The URL will usually look like this:
     https://<instance>.service-now.com/api/now/odata/v1/table_name
   • Replace table_name with the name of the table you want to query.

My problem is, I can't get this link to work. The table name, I took what was visible in the report: u_cmdb_cix_instance

For the instance, I added the company name...

Please help 🙂

Best,

Ioana

[J2LP]

Hi Ioana,

Did you try to use Dataflow. This is what we are using, thanks to that we can manage Pages during loading of data.

[Daniel Oderbolz]

Unfortunately, even tough this page https://www.servicenow.com/workflows/creator-workflows/what-is-api-integration.html mentions OData, ServiceNow does not support to offer OData APIs (but it can consume OData APIs).

If you (like me) want this to be implemented, vote for this idea please: Native functionality to offer inbound OData REST APIs