Anyone has connect PowerBI to ServiceNow using Oauth 2.0 ?

[Community Alums]

We have to connect PowerBI to ServiceNow, note that we cannot use Basic Auth, and we are required to use Oauth 2.0 authority to connect.

PowerBI would simply get data from ServiceNow.

Has anyone manage to achieve this ? 

Thank's a lot 

[Rajesh Mushke]

Hi @Community Alums ,

Follow the below steps:

1). Search for Application registry in the navigator:

2). Create the new registry:

3). I have created one to share with you:

You need to share the below highlighted details with PowerBI team:

• Name: A unique name.
• Client ID: Client ID automatically generated by ServiceNow OAuth server.
• Client Secret: Client secret for the OAuth application. Leave it empty for auto-generation.
• Redirect URL: The redirect URLs authorization server redirect to. They must be absolute URLs and they are comma separated.

Let me know if you need more help!

[Community Alums]

Hello @Rajesh Mushke

it's half of the answer.

I would like to know also PowerBI side, it looks like you have to do a custom connector to manage this ? 

But certainly ServiceNow side, it's pretty much all I we have to do. 
I would also add a REST API access policy to restrict the APIs to Oauth 2.0

Thank you

[Rajesh Mushke]

Hi @Community Alums,

Based on my past experience we can use the OOB ServiceNow Rest API to share data using basic Oath.

So Oath 2.0 connection will also work.

If you are talking about the PowerBI connector plugin then please refer the below article to know more about the details:

How to Set Power BI ServiceNow Integration: Complete Guide 

[Community Alums]

Hello,

Thank you for sharing how to use configure this store app but I doesn't mention Oauth 2.0.
It does not look like it can work.