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
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Well, it's January 10th, so is going to be Jan or when do you think?  Just wanted a guesstimate is all.

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

    • 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.