Power Bi REST API - Groups - 401

[ES_CW]

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

[v-jiascu-msft · Accepted 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

[ES_CW]

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