API that uses OAuth 2.0 for authentication

Robert4049 · ‎10-08-2018

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?

Anonymous · ‎10-10-2018

@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 · ‎10-27-2018

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.