Forum Discussion
Connecting from power BI to rest API with Oath2 authentication
- Can someone provide a sample power bi project for connecting power Bi to rest API using Oath2 authorisation.
7 Replies
- WanderingBIResolver III
I was also puzzled that the Web API connector in Power BI still does not support oAuth2.0. I wonder if anyone has developed a custom connector and made available to the public?
Currently even Google Spreadsheets third party tools for API ingestion offer support for oAuth 2.0, why not Power BI?
I have been googling for 2 days and the status is still the same:
- For stopping the frustration, Chris Webbs article is still the best ressource.
- If you have the access token, you can use Power Query to get the data, but (in most cases) you will not be able to request the access token within Power BI.
- kyrpavHelper V
If you want to publish the report, there is no solution probably at the moment i have the same problem.
Service provides basic authentication.
In desktop you can easily in one query make the first call to the login to get the token and then pass the token to the second call as authorization.
body = "{"if it is required for the sign in or you need to put somehow user and pass for sign in"}", Data= Web.Contents("https://your.sign.in.api", [Content=Text.ToBinary(body), Headers=[#"Content-Type"="application/json"]]), DataRecord = Json.Document(Data) , token=DataRecord[data], Source = Json.Document(Web.Contents("https://your.rest.api", [Headers=[#"type"="application_auth", #"Authorization"="Bearer "&token]])),- IndrasenaRegular Visitor
Is there any step by step guide like below, i am trying it for the first time as i dont have any idea on Oath2 and API authorisation,
https://www.myonlinetraininghub.com/connecting-to-an-oauth-api-like-paypal-with-power-query
It would be a great help if i can get some exact snippet M code.
- AnonymousNot applicable
Hi Indrasena
If you want to connect from Power BI to a REST API that uses OAuth2 authentication then you need to build a custom connector. You can find documentation on how to implement an OAuth2 flow in a custom connector here.
For reference: Connecting To REST APIs With OAuth2 Authentication In Power Query/Power BI
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- IndrasenaRegular Visitor
Please find the below snippet code and need some inputs for looping,triggering the web api and store each response as record.
- Sarath_babu2New Member
I came across the same requirement and the solution in below link worked for me. Document was very clear and explained step by step in detail.
https://www.advaiya.com/generate-dynamic-token-and-get-data-from-custom-api-in-power-bi/