Forum Discussion
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
- AnonymousNot 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- RayGn2000Frequent 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.
- AnonymousNot applicable
Hi RayGn2000,
Have you checked the setting of the azure web app configuration to confirm if power bi URLs are in the allow list?
Azure App Service access restrictions - Azure App Service | Microsoft Docs
BTW, you can also contact azure support to confirm if they have limits on the rest API usage when you host on the azure side.
Regards,Xiaoxin Sheng