cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Robert4049
Frequent Visitor

API that uses OAuth 2.0 for authentication

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?

3 REPLIES 3
v-yuezhe-msft
Microsoft
Microsoft

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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.

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors