topic Re: API Export with captured bookmark state only has current page filters in Developer

API Export with captured bookmark state only has current page filters

benw101010 — Mon, 12 Jun 2023 16:33:12 GMT

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.

Re: API Export with captured bookmark state only has current page filters

AmosHersch — Tue, 13 Jun 2023 07:57:00 GMT

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?

Re: API Export with captured bookmark state only has current page filters

benw101010 — Tue, 13 Jun 2023 13:49:36 GMT

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;

Re: API Export with captured bookmark state only has current page filters

AmosHersch — Tue, 13 Jun 2023 19:15:51 GMT

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.

Re: API Export with captured bookmark state only has current page filters

benw101010 — Wed, 14 Jun 2023 15:16:28 GMT

I found my issue - I needed to update powerbi.js. Exported pdf now has page level filters from captured bookmark.

https://github.com/microsoft/PowerBI-JavaScript/tree/master/dist