Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
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.
Solved! Go to Solution.
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
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.
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
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;
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?
User | Count |
---|---|
13 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
13 | |
6 | |
3 | |
2 | |
2 |