User Profile
RayGn2000
Frequent Visitor
Joined 5 years ago
User Widgets
Contributions
Re: Power BI Bearer token REST API throws error The remote server returned an error: (400) Bad Request.
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.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; }Compare fields side by side from same dataset with grouping and filter Slicer
I have a dataset which has historical data from year to year. I want to compare what changed in year to year using slicer by taking data from the same dataset. I can even duplicate the data source if required. The data coming from SQL looks like this I want to build a PBI matrix report by comparing data from 2 Years data. There are 2 dropdowns for year so that I can compare with any year data with another year. any advice is appriciated. Can this be achievable in PBI report with one dataset?Seguridad a nivel de fila con conjunto de datos compartido de Power BI
Tengo problemas al aplicar la seguridad de nivel de fila en el informe de Power BI mientras uso un datset compartido desde un área de trabajo. Puedo conectarme a un conjunto de datos PBI existente y puedo crear un informe, pero no puedo aplicar la seguridad de nivel de fila. El elemento de menú está deshabilitado. ¿Hay alguna forma de lograr esto? Nota: la seguridad de nivel de fila funciona correctamente con el conjunto de datos de nivel de informe.Row level security with Power BI Shared Dataset
I have issue in applying row level security in Power BI report while using a shared datset from a workspace. I am able to connect to an existing PBI dataset and able to create report but I am not able to apply row level security. The menu item is disabled. Is there any out of the box way to achieve this? Note - row level security works fine with report level dataset.
