Connecting REST API with OAUTh authentication

[mrvamsidhar]

We are having internal application RestAPI calls authenticated with my company Azure AD with OAuth2 . I can able to make those call from browser. But how can I make call those API's from Power-BI desktop application?

I tried with all Authentication mechanisms. I am getting error message saying "Access to resource is forbidden".

1. Is oAuth2 supported by Power-BI?
2. How can i connect to the rest api calls?

Thanksin advance

[v-yuta-msft]

Hi mrvamsidhar,

Yes, power bi support OAuth, please click Query Editor-> Advanced editor then use web.content() function. Please refer to these blogs for more detail about how to make http request in power bi desktop with OAuth:

http://bi-fu.net/pbi/add-headers-for-oauth2-in-power-query-web-contents-for-power-bi/

https://prathy.com/2017/09/calling-power-bi-api-using-power-bi-desktop-to-document-power-bi-service/

https://stackoverflow.com/questions/40753188/google-oauth-refresh-tokens-in-power-query

https://wiki.zansha.space/index.php/SSO_Authentication_in_Microsoft_Power_Query

Regards,

Jimmy Tao

[mrvamsidhar]

Thanks Jimmy. I was succedded little bit. All these urls provided below showed hot to use Temporary cookie. At the same time, Our rest API's are using Cookie based Authentication. I am able to use existing token which I got from browser and able pull data.

1. So is it possible to create a authorization cookie using M query and pass cookie details to REST API instead using existing cookie? 

[v-yuta-msft]

Hi mrvamsidhar,

I'm afraid you can't create cookie using power query because power query can only get data, but can't output cookie files.

Regards,

Jimmy Tao 

[mrvamsidhar]

So, is there a way i can acheive this?

All i want is to call these rest apis from powerbi and publish the report.

Are there any other alternatives?

[mrvamsidhar]

Can some one help me with this? Our REST API's are using OAuth with AZure teantid. After login with Azure credential, my rest api's works fine in my broswer. But when I open the rest api's in my powerbi, it is asking not working. But, If i provide cookie from the browser to the powerbi (GetData->Web->Advanced) it is giving data. I like to implemt OAuth in my powerbi desktop.

Can it be done via connectors or power query?

How to get Authorize token for azure in power query ( I have tenant id)