Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.