Forum Discussion

RayGn2000's avatar
RayGn2000
Frequent Visitor
5 years ago

Power BI Bearer token REST API throws error The remote server returned an error: (400) Bad Request.

I am trying to refresh PBI dataset programmatically and to do so I am trying to get oath beaer token using the code below. The code works fine with a console app. But when I embed the code into a WCF web service and deploy in a web app then it throws 400) Bad Request error. The reason I had to pass user id and password because the WCF web service will run in backend anf will not have any GUI interaction for user authentication. 

 

resource -> https://analysis.windows.net/powerbi/api

authority -> https://login.microsoftonline.com/*****tenant Id****/oauth2/token

cleint id and ApplicationSecret has been collected from PBI app registration.

 

 

StringBuilder body = new StringBuilder();
            body.Append("resource=" + HttpUtility.UrlEncode(resourceUri));
            body.Append("&client_id=" + HttpUtility.UrlEncode(ApplicationID));
            body.Append("&grant_type=" + HttpUtility.UrlEncode("password"));
            body.Append("&username=" + HttpUtility.UrlEncode(userid));
            body.Append("&password=" + HttpUtility.UrlEncode(password));
            body.Append("&client_secret=" + HttpUtility.UrlEncode(ApplicationSecret));
            
            using (WebClient web = new WebClient())
            {                
                web.Headers.Add("Content-Type", "application/x-www-form-urlencoded");               
                string data = web.UploadString(authority, body.ToString()); // this line throws error
                dynamic result = JsonConvert.DeserializeObject(data);
                try
                {
                    return result.access_token;
                }
                catch
                {

                }
                return null;
            }

5 Replies

Replies have been turned off for this discussion
  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi RayGn2000,

    Where are you host the WCF service? Did these host on the same device that you tested the console application? Please share more detailed information to help us clarify your scenario:

    How to Get Your Question Answered Quickly 

    In addition, please also take a look at the following link about power bi service URLs if you do not configure them on your server white list:

    Add Power BI URLs to allow list - Power BI | Microsoft Docs

    Regards,
    Xiaoxin Sheng

    • RayGn2000's avatar
      RayGn2000
      Frequent Visitor

      Hello Xiaoxin  - 

       

      I have hosted the WCF service in an Azure web app. The console application works fine in my local computer (VS2019) and I always get a true oauth2 token.

       

      When I  access the WCF web service (using web app URL) it throws 400 bad request error.