Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hey for quite some time I'm trying to connect to the Power BI Servvice using the R package httr. Until now without any success.
I'm trying to get an access token for further use ...
Currently my R code looks like this
library("httr"); library("httpuv") powerbi.urls <- oauth_endpoint( NULL, "authorize", "token", base_url = "https://login.windows.net/common/oauth2") powerbi.app <- oauth_app( "myAppName", key="myClientID", secret="myClientSecret" ) powerbi.token <- oauth2.0_token(powerbi.urls, powerbi.app) powerbi.token
The package httpuv is just used to provide a local web server using port 1410.
I used this page
https://dev.powerbi.com/apps?type=web
to create a client-id and a client-secret for a web-app "myAppname".
I'm aware of the documentation how to connect to the Power BI Service and also aware of this site
https://www.codeproject.com/tips/1042542/connecting-to-power-bi-rest-api-from-a-service-i-e
But I'm not able to translate the C# examples to the proper parameter for the httr functions.
I'm able to connect to linkedin and git using httr, but not to the Power BI Service
For this reason, any help is much appreciated, even direct comments like
Solved! Go to Solution.
Ha, if you think a little longer and then you change your code a little and it works
library("httr"); library("httpuv") # #oauth_endpoints("azure") powerbi.urls <- oauth_endpoint( "authorize", "token", base_url = "https://login.windows.net/common/oauth2") powerbi.app <- oauth_app( "myAppName", key="myClientID", secret="myClientSecret" ) powerbi.token <- oauth2.0_token(powerbi.urls, powerbi.app, user_params = list(resource = "https://analysis.windows.net/powerbi/api"), use_oob = FALSE)
Ha, if you think a little longer and then you change your code a little and it works
library("httr"); library("httpuv") # #oauth_endpoints("azure") powerbi.urls <- oauth_endpoint( "authorize", "token", base_url = "https://login.windows.net/common/oauth2") powerbi.app <- oauth_app( "myAppName", key="myClientID", secret="myClientSecret" ) powerbi.token <- oauth2.0_token(powerbi.urls, powerbi.app, user_params = list(resource = "https://analysis.windows.net/powerbi/api"), use_oob = FALSE)
Hi @TomMartens,
I've tried this approach with the same R code, but I'm receiving a below error in a browser:
Sign in Sorry, but we’re having trouble signing you in. AADSTS50011: The reply url specified in the request does not match the reply urls
configured for the application: 'value for clientID'.
Is it working today from your side?
Regards,
Ruslan
User | Count |
---|---|
25 | |
22 | |
11 | |
10 | |
9 |
User | Count |
---|---|
48 | |
30 | |
20 | |
17 | |
15 |