ServiceNow Power BI Integration

[itspezi1]

Hello team,

How can you create an interface to Microsoft Power Bi to make data available there? I don't want to purchase any more products. The solution must work with ServiceNow's on-board resources.

BR

[Marcos Kassak]

Hi @itspezi1,

I recommend that users take advantage of ServiceNow for their reporting needs, especially with the upcoming improvements in Platform Analytics. However, if you still prefer PowerBI, you can use the Table APIs from ServiceNow. To access the necessary data, you'll need to create an integration account with read permissions to the tables that you need to extract information.

Make sure to use parameters like sysparm_display_value, sysparm_limit, sysparm_fields, and sysparm_query - these types of connections need good governance around them so it does not get out of control, so be aware of that.

https://docs.servicenow.com/bundle/xanadu-api-reference/page/integrate/inbound-rest/concept/c_TableA...

If you found my answer helpful or correct ✔️ in any way, please don't forget to mark it to help future readers! 👍

--

Kind regards,

Marcos Kassak
Solution Consultant  🎯

[Marcos Kassak]

Hi @itspezi1,

Do you need further assistance on this matter? Happy to help. If you feel like it, don't forget to mark the answer as correct to help future readers.

Thank you!