topic Re: Embed group report problem in Developer

Embed group report problem

vospitannikov — Mon, 05 Sep 2016 13:33:05 GMT

I'm trying to integrate PowerBI report (located in group) into my page using iframe

I've registered AD application

I can query list of reports from the server side

But when I'm trying to use received "embedUrl" value using the same token I'm getting following error message:

"This content is not available.
Learn more about Power BI."

At the same time, if I open list of network requests in chrome DevTools, I can see the one request to some page ending in "modelsAndExploration" which return 401 error: Unauthorized

If I'm trying to open URL received in webUrl, I can successfully see report in PowerBI interface

Any suggestions/ideas?

Re: Embed group report problem

Eric_Zhang — Tue, 06 Sep 2016 09:36:53 GMT

@vospitannikov

How did you embed the report, did you follow this sample Integrate a report into an app?

Also please ensure the token is not expired, did you try to get a new token and embed?

Re: Embed group report problem

vospitannikov — Tue, 06 Sep 2016 09:47:08 GMT

@Eric_Zhang, yes, I followed exactly these instructions

and I'm pretty sure that token is valid - I can get the list of reports using GET request (https://api.powerbi.com/v1.0/myorg/groups/{someGroupId}/reports)

The only one difference between example and my code - that I'm trying to integrate group report, not default one

Re: Embed group report problem

vospitannikov — Tue, 06 Sep 2016 13:10:38 GMT

@Eric_Zhang, I've integrated default report (not group one) and it works fine

Only groups reports cause mentioned above error

Re: Embed group report problem

Eric_Zhang — Wed, 07 Sep 2016 03:26:13 GMT

@vospitannikov wrote:

I'm trying to integrate PowerBI report (located in group) into my page using iframe

I've registered AD application

I can query list of reports from the server side

But when I'm trying to use received "embedUrl" value using the same token I'm getting following error message:

"This content is not available.
Learn more about Power BI."

At the same time, if I open list of network requests in chrome DevTools, I can see the one request to some page ending in "modelsAndExploration" which return 401 error: Unauthorized

If I'm trying to open URL received in webUrl, I can successfully see report in PowerBI interface

@vospitannikov

Thanks for the clarification. I can embed the reports from groups well.

Regarding the bold part, do you mean that in web Url, you can embed the reports from groups without problem? If yes, what do you mean "in webUrl"?

Re: Embed group report problem

supermulder — Wed, 07 Sep 2016 05:13:38 GMT

I have exactly the same issue.

Embedding of my own reports works fine.

I have created 4 groups in power bi - only one report in one group can be embedded without a Problem, all reports that are within the other 3 groups can not be embedded (401 Unauthorized) - the group permissions are all the same.

Another problem:

I have written a small javascript function to switch dynamicly between reports. At this moment i try to load a report that does not work (see above) some error-handling goes wrong and the function does not longer work, i´m not able to embed the working report anymore - i think there is some error handling missing in your underlying powerbi.js framework.

function switchReport(id){
    var embedConfiguration = {
        type: 'report',
        id: id,
        accessToken: '{{AccessToken}}',
        embedUrl: 'https://app.powerbi.com/reportEmbed'
    };
    var $reportContainer = $('#reportContainer');
    var report = powerbi.embed($reportContainer.get(0), embedConfiguration);

}

Re: Embed group report problem

supermulder — Thu, 08 Sep 2016 08:10:37 GMT

Some additional infos:

- I can embed all reports that are attached to my workspace

- I can only embed reports from other workspaces if i attached them to a group dashboard that is shared with my user

It seems that the group-permissions that i´ve configured in the group-configuration are not considered in the embedding process 😞 So i´m only able to embed such reports in which i get a "permission" through the process of dashboard-sharing ...

Is this a known issue at the moment ? I would appreciate any help! Thank you!

Re: Embed group report problem

vospitannikov — Thu, 08 Sep 2016 08:21:51 GMT

Hello @Eric_Zhang

Thank you for your response

By "webUrl" I mean data received during requesting reports from API (please pay attention to bolded text below)

http://docs.powerbi.apiary.io/#reference/report-preview/reports-collection/list-all-reports

{
  "@odata.context": "https://api.powerbi.com/beta/myorg/$metadata#reports",
  "value": [
    {
      "id": "84dbd390--5eb9fe91cdba",
      "name": "AdventureWorks",
      "webUrl": "https:// app.powerbi.com/reports/84dbd390---5eb9fe91cdba",
      "embedUrl": "https://app.powerbi.com/embedReport?reportId=84dbd390--5eb9fe91cdba"
    }
  ]
}

I still facing the same problem during embedding group reports

and located in my personal workspace reports can be embed without any problems

@Eric_Zhang, have you configured any special permissions for datasets/reports in order to let them be shared via embedding?

Re: Embed group report problem

Eric_Zhang — Fri, 09 Sep 2016 03:02:20 GMT

@vospitannikov

Would you mind uploading the project in VS? By the way, ensure all the options are checked when registering an app for PBI.

Re: Embed group report problem

supermulder — Mon, 12 Sep 2016 09:18:07 GMT

@Eric_Zhang Do you have any idea / hint regarding my posts above ?

Re: Embed group report problem

supermulder — Tue, 13 Sep 2016 05:03:01 GMT

Here are some additional information of what happened in the background:

Chrome Console:

Call Response:

{"error":{"code":"UnknownError","pbi.error":{"code":"UnknownError","parameters":{},"details":[]}}}

Behaviour:

Embedding of reports that are directly attachted to my workspace works without any problem
Embedding of group-reports that are shared additionaly through a dashboard-sharing works even too
Group-reports with the correct permission for my user (i´m able to view them in powerbi online) cannot be embedded, instead of the report i get the message "This content is not available" and the error described above.

Access-Token Generation:

$session = $this->get("session");
        $provider = new \TheNetworg\OAuth2\Client\Provider\Azure([
            'clientId'          => $this->clientId,
            'clientSecret'      => $this->clientSecret,
            'redirectUri'       => $this->redirectUri,
            ''
        ]);
        if (!isset($_GET['code'])) {
            // If we don't have an authorization code then get one
            $authUrl = $provider->getAuthorizationUrl();
            $session->set("oauth2state",$provider->getState());
            header('Location: '.$authUrl);
            exit;

        } else {
            $token = $provider->getAccessToken('authorization_code', [
                'code' => $_GET['code']
            ]);
        }

Token - Values Dump:

array:7 [▼
  "token_type" => "Bearer"
  "scope" => "Dashboard.Read.All Dataset.ReadWrite.All Group.Read Report.Read.All"
  "ext_expires_in" => "0"
  "expires_on" => "1473745814"
  "not_before" => "1473741914"
  "resource" => "https://analysis.windows.net/powerbi/api"
  "id_token" => "...."
]

Question:

Is it possible that i have to do something additional to get an accesstoken that provides access to group workspaces instead of having only access to reports / dashboards that are directly attached to my workspace ?

Re: Embed group report problem

vospitannikov — Tue, 13 Sep 2016 07:09:33 GMT

Hello @Eric_Zhang

I've uploaded project where I can reproduce this error to GitHub

https://github.com/vospitannikov/PowerBIGroupReportIntegrationError

Please pay attention to "TODO" comments in order to set all needed data

Also, you need to create PowerBI application before running this project

You need access to some PowerBI group with report

1. access to some PowerBI group with report (in order to reproduce this error)

2. some not group report (in order to see that it works fine for general reports, not group one)

Please let me know if you can reproduce this error

Re: Embed group report problem

vospitannikov — Tue, 13 Sep 2016 07:10:24 GMT

@Eric_Zhan, all PowerBI application settings permissions was checked

Re: Embed group report problem

vospitannikov — Tue, 13 Sep 2016 07:12:31 GMT

@supermulder, I've got same error - 401 during accessing .../modelsAndExploration URL

and the same error text:

{"error":{"code":"UnknownError","pbi.error":{"code":"UnknownError","parameters":{},"details":[]}}}

Re: Embed group report problem

supermulder — Mon, 19 Sep 2016 05:01:25 GMT

@vospitannikov Have you found a solution in the meantime ?

Re: Embed group report problem

vospitannikov — Tue, 20 Sep 2016 08:26:08 GMT

@supermulder, no, embedding group reports doesn't work 😞

Re: Embed group report problem

supermulder — Tue, 20 Sep 2016 18:03:02 GMT

@Eric_Zhang Any ideas left ? Maybe it´s neccesarry to provide the workspace-id for a specific power bi group to read the reports from this group ?

Re: Embed group report problem

smolina74 — Tue, 20 Sep 2016 20:32:03 GMT

same issue happened to me.

When trying to access to reports in groups that were created in the last few days we cannot do it. We're getting the same 401 error. Now, if we try to access to reports in groups that were created say 3 months ago, we have no issue.

Another thing to mention. If you login to Power BI portal with the same account you're using for accessing the reports and then try your application (in the same browser instance) you will be able to access to those reports.

It seems like extra cookies saved during the login to the Power BI portal are helpful in these cases. So, the problem is not is not the access token itself.

Re: Embed group report problem

Eric_Zhang — Wed, 21 Sep 2016 05:36:14 GMT

@vospitannikov

I follow the tutorial and it works loading report from a group and have now further idea on what exactly happens in your case. Maybe you will ask for support from Microsoft.

Re: Embed group report problem

supermulder — Wed, 21 Sep 2016 05:38:27 GMT

@Eric_Zhang

Which tutorial did you follow ?