Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Power BI Embed - issue with Paginated report visual

I am starting with Power BI Embed, so not an expert. I have started with sample code for Power bI Embed and having issue with Power BI report having Paginated report visual. Information about my con...
Need Help
AmosHersch's avatar
AmosHersch
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

Basically most errors in such cases are related for you "Generate token" request. Basically it should include the ID of the Power BI report, the ID of the Paginated report, the ID of the Power BI dataset with "xmlaPermissions" parameter set to "ReadOnly". Other values might depend on your specific configuration (datasources, RLS, etc.).

Did you see this sample of such request: https://docs.microsoft.com/en-us/power-bi/developer/embedded/embedded-faq#how-can-i-embed-a-power-bi-report-that-contains-a-paginated-report-visual- 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you AmosHersch 

    I have starte with "Sample .Net Framework AppsOwnsData solution", and basically revised little to pass on report Guid List to to "GenerateToken" function ..something like this in sample code
    var reportList = new List<Guid>();
    reportList.Add(new Guid("<PBI report GUID>"));
    reportList.Add(new Guid("<Paginated Report GUID>"));
    embedToken = await GetEmbedToken(reportList, datasetIds, workspaceId);

    But now i get error message saying "bad reqeust(400); RDL report cannot connect to dataset". 
    I have verfied that Service Principal has access to {dataset, Report, Paginated report}. I am able to successfully run the report and view paginated report in service and even in "PBI Playground area" without any issue. It is just in my visual studio .net framework solution when executed in debug mode using Service principal... it fails with error. 

    Please advise.