API that uses OAuth 2.0 for authentication

[Robert4049]

Hey Everyone,

I'm trying to use an API that uses OAuth 2.0 for authentication; the problem lies in the fact that there's no Session Token and it requires my credentials to log into the app; I've managed to capture some session tokens, but they do expire. I'm not really sure what to do here?

[v-yuezhe-msft]

@Robert4049,

You can take a look at the following example about how to connect to API using OAuth 2.0 in Power BI.

http://angryanalyticsblog.azurewebsites.net/index.php/2016/05/16/api-strategies-with-power-bi/

Alternatively, you can create  custom data connector for your data source in Power BI following the guide in this article. And you can check OAuth authentication here.

Regards,
Lydia

[amiller]

I've followed this example to get an OAuth token, add it to the header in a call to our API service, and have it working from Power BI Desktop.  However, I can't seem to configure automated refresh from the Power BI service portal for this data source.  I recieve the message "Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again."  How do I configure automated refresh for a data source based on this approach to authentication?  Any help is appreciated, this is a pretty big road block if we can't get it working.

[v-yuezhe-msft]

@amiller,

Please check my reply in the following thread.

https://community.powerbi.com/t5/Integrations-with-Files-and/How-to-refresh-ODATA-API-with-OAuth2/td...

Regards,
Lydia