Puling the data from a REST API

[Anonymous]

Hi All,  am trying to create a report puling the data from a REST API. The API however is secured using oAuth2, so in order to pull the data, an API call must first be made to /login/token API (using basic authentication) and the token returned needs to be used to authenticate the actual API call pulling the data.  Is this possible with PowerBI

Can you please suggest on this ?

[Anonymous · Accepted solution]

Hi @Anonymous,

You can take a look following link to know how to use web connector to get data from the rest API with authentication:

Pull data from a REST API Authentication 

If these not help, please some more railte about the definition/documents of your rest api then we can write some sample code of them.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Check out this previous solution if this can help

https://community.powerbi.com/t5/Desktop/Connecting-REST-API-with-OAUTh-authentication/td-p/424738

Another example

https://community.powerbi.com/t5/Desktop/Power-Query-Open-ID-and-OAuth-2-0-Rest-API/td-p/693162