Forum Discussion

JAnder's avatar
JAnder
Helper II
4 years ago
Solved

Embedded paginated report with PowerBI dataset

In Feb the option of using a Power BI dataset was introduced for embedded paginated reports.  https://powerbi.microsoft.com/en-us/blog/power-bi-february-2022-feature-summary/#post-18588-_Toc95419023...
Tutorial Requests
JAnder's avatar
JAnder
Helper II
4 years ago

I found that looking at the request on Fiddler gives more info that the exception shows. It actually didn't want my effective identity at all. I took out the identity and got the token.

 

{
    "error": {
        "code": "InvalidRequest",
        "message": "Creating embed token for accessing dataset <removed> shouldn't have effective identity"
    }
}

 

 

MichaelWash's avatar
MichaelWash
Helper I
4 years ago

Can you show me your code?

  • JAnder's avatar
    JAnder
    Helper II
    4 years ago

    So it ends up looking like this and is working for now showing the reports. I should say I dont create the report or do the Power BI admin stuff, so there may be settings which now cause me to leave out the identity.

     

    I did try using dynamic binding with this but it seems the token request always needs the datasetId used when creating the report. If I supply both (original and one I want to use) it seems to work but I only tested that against a dataset copy, needs more work to know if it is binding to correct dataset.

     var reports = new List<GenerateTokenRequestV2Report>() { new GenerateTokenRequestV2Report(report.Id) };
 var datasets = new List<GenerateTokenRequestV2Dataset>() { new GenerateTokenRequestV2Dataset(datasetId, XmlaPermissions.ReadOnly) };
 var workspaces = new List<GenerateTokenRequestV2TargetWorkspace>() { new GenerateTokenRequestV2TargetWorkspace(groupId) };
                
 var tokenRequest = new GenerateTokenRequestV2(datasets, reports, workspaces, null);
 var embedToken = client.EmbedToken.GenerateToken(tokenRequest);

 return embedToken;