Forum Discussion

benw101010's avatar
benw101010
New Member
3 years ago
Solved

API Export with captured bookmark state only has current page filters

When I pass the bookmark state to request PowerBIClient.Reports.ExportToFileInGroup, only the filters / slicers for the current page are applied to resulting export (powerpoint).

 

In javascript, I'm capturing the bookmark from an embedded PBI report...

 

.report.bookmarksManager.capture({
allPages: true,
personalizeVisuals: true
})

 

Please advise if there is a way to get filters from all pages in an export report.

 

4 Replies

  • AmosHersch's avatar
    AmosHersch
    Microsoft Employee

    Hi benw101010 ,

     

    Can you please share how the request to the API looks like?

    Do you just pass the captured bookmark state in the defaultBookmark parameter?

  • yes defaultBookmark.  c# server side code...

     

    var powerBIReportExportConfiguration = new PowerBIReportExportConfiguration
    {
    Settings = new ExportReportSettings
    {
    Locale = "en-us",
    },
    // Note that page names differ from the page display names
    // To get the page names use the GetPages REST API
    Pages = pageNames?.Select(pn => new ExportReportPage(pn)).ToList(),
    DefaultBookmark = new PageBookmark(null, bookmark.state),
    Identities = identities
    };

    var exportRequest = new ExportReportRequest
    {
    Format = format,
    PowerBIReportConfiguration = powerBIReportExportConfiguration,
    };

    // The 'Client' object is an instance of the Power BI .NET SDK
    var export = await client.Reports.ExportToFileInGroupAsync(groupId, reportId, exportRequest);
    // Save the export ID, you'll need it for polling and getting the exported file

    var result = new ExportRequest()
    {
    ExportId = export.Id,
    ReportName = report.Name,
    ReportId = reportId,
    GroupId = groupId
    };
    return result;

     

  • AmosHersch's avatar
    AmosHersch
    Microsoft Employee

    Not sure why it's not working. Might be a bug on Power BI side but requires investigation.

    Since you are already using Power BI JS to capture the bookmark I would try to apply the captured bookmark state and see if it works or not.