Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Embedding Paginated Report with a Power BI Dataset

Hello. I am trying to embed a paginated report in my web application that uses a Power BI Dataset as its datasource. I can get the embed token, but when rendering it, I am getting this error:    ...
Need Help
Tips and Tricks
Tutorial Requests
avive's avatar
avive
Power BI Team
4 years ago

Please give it another week

Thanks

Aviv

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    So, we have implemented the code in our .net application and we are able to see our paginated report through our embedded web application. However, we are seeing an issue where the provided EffectiveIdentity username is not showing correctly in the Paginated Report's username parameter. This parameter is showing the &User.UserId property, however, this value has the service principal GUID instead of the effective identity username provided in the api call. Code in call: 

     

    generateTokenRequestV2Parameters = new GenerateTokenRequestV2(datasets: dataSetIdV2, reports: reportIdV2, identities: new List<EffectiveIdentity> { new EffectiveIdentity(username: upn, roles: new List<string> { roleName }, datasets: new List<string> { dataSetId }) });

     

    accessToken = client.EmbedToken.GenerateToken(generateTokenRequestV2Parameters);

     

    The upn value in this case is my email address '[email protected]', which should show up in the pagainated report parameter for &User.UserId instead of the SPN GUID.

    • AmosHersch's avatar
      AmosHersch
      Microsoft Employee
      4 years ago

      Hi,

       

      When you provide an effective identity in the generateToken request it should either be an effective identity for the paginated report or an effective identity for the Power BI dataset.

      If you want the username to be the identity passed to the report then should should provide the reportId and not the datasetId. Something like this:

       new EffectiveIdentity(username: upn, , reports: new List<string> { reportId })

      In addition you can specify another identity for the dataset, with the roles, etc.

       

      Thanks,

      Amos

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Thank you, that was very helpful. In order to make it work, I had to provide both identities (one for report, one for dataset) otherwise I would get a bad request error. Would you happen to have any documentation on using multiple identities? I don't think I would have ever thought to do that, so thank you.

  • srarden's avatar
    srarden
    Regular Visitor
    4 years ago

    Trying to test this out this feature in paginated reports using the embed .NET example code locally, and getting the error: 

     

    Could not connect to the data source.

    There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page.
     
    Both the report and underlying dataset are in the same workspace which is attached to a premium per capacity.  Able to embed and reach the dataset in regular Power BI reports embedded, so the gateway is okay - using ServicePrincipal.