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.
Hello all,
I have been working on troubleshooting an issue in the power BI service and am pretty stuck. With a .NET console app, I am able to create and get a dataset as well as add rows to a table in the dataset. I cannot do an HTTP GET to "https://api.PowerBI.com/v1.0/myorg/groups" without getting a 401 using the same creds to do the work around the dataset.
Relevant details:
1) This is a native app
2) I have tried both the auth token for the app and also using the user context
3) I am the owner of the app in Azure AD and have admin access to the Power BI site for our org
4) All permissions have been set for power bi and 3 for AAD:
Code:
{ string powerBIGroups = "https://api.PowerBI.com/v1.0/myorg/groups"; HttpWebRequest request = System.Net.WebRequest.Create(powerBIGroups) as System.Net.HttpWebRequest; request.KeepAlive = true; request.Method = "GET"; //Add token to the request header request.Headers.Add("Authorization", String.Format("Bearer {0}", token)); string datasetId = string.Empty; //Get HttpWebResponse from GET request using (HttpWebResponse httpResponse = request.GetResponse() as System.Net.HttpWebResponse) { //Get StreamReader that holds the response stream using (StreamReader reader = new System.IO.StreamReader(httpResponse.GetResponseStream())) { string responseContent = reader.ReadToEnd(); var results = JsonConvert.DeserializeObject<dynamic>(responseContent); //Get the first id datasetId = results["value"][0]["id"]; Console.WriteLine(String.Format("Dataset ID: {0}", datasetId)); Console.ReadLine(); return datasetId; } } }
The error is thrown at "using (HttpWebResponse httpResponse = request.GetResponse() as System.Net.HttpWebResponse)":
An unhandled exception of type 'System.Net.WebException' occurred in System.dll
Additional information: The remote server returned an error: (401) Unauthorized. occurred
Any ideas? I would like to get the dataset into a group so I can share with others in the org.
Eric
Solved! Go to Solution.
Hi @ES_CW,
1. Did you click the "Grant permissions" after select the permission items?
2. Did you have a step that would retrieve the token before this step?
Best Regards,
Dale
Hi @ES_CW,
1. Did you click the "Grant permissions" after select the permission items?
2. Did you have a step that would retrieve the token before this step?
Best Regards,
Dale
Thanks Dale. I had thought I had the access, as it shows all access granted, but I am not an admin for the Azure AD instance, and as it turns out, even though I didn't have access granted, it showed that I did. That was my downfall.
So - your fix above worked. I just had a false positive in the dashboard, and I made the assumption that it was granted. At any rate, it is now.
Thanks!
Eric
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.
User | Count |
---|---|
16 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
21 | |
2 | |
2 | |
2 | |
2 |