Forum Discussion
Export to file - Power BI Report with Filters / Parameters
Hi Anonymous
The documentation currently states that the Bookmark name (whilst accepted as a parameter) is not currently available.
https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofile#pagebookmark
The only way to update output via bookmarks, is to pass in the bookmark state.
And the only way that you can get the bookmark state (that I know of) is via the JavaScript API. https://github.com/Microsoft/PowerBI-JavaScript/wiki/Bookmarks#capture-and-get-a-current-view-as-a-bookmark-object-and-apply-it-back-on-the-current-session
The 'capture' function will return a single string value that represents the bookmark state. You can then pass this into the API.
This is far from ideal... but I think the export API endpoint is still under preview, so will likely change quite a bit.
The idea I raised for adding missing functionality to this API has also moved into the planned phase. So hopefully, it won't be too long before these missing features are available. https://ideas.powerbi.com/ideas/idea/?ideaid=0e056f7d-34b4-4778-974f-929228effcdd
Cheers, Matt
Post PatronHi Anonymous,
We have an independent solution to the PDF export problem. We've built a tool called BI Helper https://bihelper.tech/ to automate the generation of PDF / PPTX reports from Power BI (Pro and Premium), with slicers and filters applied. Our implementation bypasses the limitations of the API endpoints.
With BI Helper, you can select report pages to print, schedule and generate multi-page PDF / PPTX reports and email them to your users. BI Helper has an option to include matrix and table visuals as Excel files, and lots of other advanced features. Our users routinely run hundreds of reports of up to 30 pages each, with the process fully automated from report generation to delivery.
BI Helper is simple to configure and use with your Power BI reports and dashboards. It is secure and scalable and offers a 14 day free trial. Try it out and let us know how it works for you.
Kiran Hosakote
BI Helper