topic Re: How to generate authorization token in R? in Developer

How to generate authorization token in R?

zoloturu — Sat, 07 Jul 2018 20:28:08 GMT

Dear community,

I'm trying to generate an authorization token to Power BI Service in R. Thanks to Tom Martens there is his experience mentioned in this topic - https://community.powerbi.com/t5/Service/connect-to-Power-BI-Service-using-R/m-p/119697#M18632

When I tried, it was unsuccessful. Can somebody help to find out what is wrong in below R script?

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="my_client_id-value", 
  secret="my_secret_id-value"
)

powerbi.token <- oauth2.0_token(powerbi.urls, powerbi.app,
                                user_params = list(resource = "https://analysis.windows.net/powerbi/api"),
                                use_oob = FALSE)

Regards,

Ruslan

Re: How to generate authorization token in R?

v-jiascu-msft — Tue, 10 Jul 2018 03:06:31 GMT

Hi Ruslan,

What's the error message?

I added a parameter to "oauth_endpoint". It worked. Please give it a try.

library("httr");
library("httpuv")

# 
#oauth_endpoints("azure")
powerbi.urls <- oauth_endpoint(
  NULL,
  "authorize",  
  "token",
  base_url = "https://login.windows.net/common/oauth2")

powerbi.app <- oauth_app(
  "myAppName",
  key="my_client_id-value", 
  secret="my_secret_id-value"
)

powerbi.token <- oauth2.0_token(powerbi.urls, powerbi.app,
                                user_params = list(resource = "https://analysis.windows.net/powerbi/api"),
                                use_oob = FALSE)

Best Regards,

Dale

Re: How to generate authorization token in R?

zoloturu — Sat, 14 Jul 2018 19:40:58 GMT

Hi Dale @v-jiascu-msft,

I've tried with your addition. But error persists. See it below:

browser error

Regards,

Ruslan

Re: How to generate authorization token in R?

v-jiascu-msft — Mon, 16 Jul 2018 01:25:58 GMT

Hi Ruslan,

As we can see from the error message, it seem the redirect URL isn't the same between your settings and the Azure settings. Please refer to the snapshot below and check out.

Best Regards,

Dale

Re: How to generate authorization token in R?

v-jiascu-msft — Sun, 22 Jul 2018 13:35:56 GMT

Hi @zoloturu,

Could you please mark the proper answer as a solution?

Best Regards,
Dale

Re: How to generate authorization token in R?

zoloturu — Sun, 22 Jul 2018 14:15:39 GMT

Hi Dale @v-jiascu-msft,

I didn't receive any solution so far. I tried to add localhost in Azure portal to app registrations as you told, but it didn't help. I opened a MS ticket for that. You can check it with number 118071418582124.

Regards,

Ruslan