topic Re: Power BI REST API: Problems exporting multi-page reports with bookmarks in Developer

Power BI REST API: Problems exporting multi-page reports with bookmarks

Anonymous — Tue, 29 Dec 2020 15:57:59 GMT

Hi,

I'm using the Export To File In Group REST endpoint to export a multi-page report with bookmarks to PNG, and I'm running into problems.

Basically, during a export request I want to render each page in the report in the same filter state, as specified by a bookmark. The bookmarks in the report only memorize the state of the filters ("Data").

I've obtained the identifying bookmark names (NOT the displayNames) using the PowerBI Javascript API. I'm not selecting the bookmarks using the bookmark state.

I have encountered the following problems when exporting:

Supplying the bookmark as the defaultBookmark for all the pages doesn't have any effect. It's completely ignored.
If, as a workaround, I request each report page explicitly ,requesting the same bookmark each time, then the bookmark is respected, but each of the exported PNG files becomes an exact copy of the first report page! This doesn't happen when not requesting any bookmark; in that case each PNG reflects its proper page.

Is there any solution or workaround for these problems?

Re: Power BI REST API: Problems exporting multi-page reports with bookmarks

lbendlin — Tue, 29 Dec 2020 18:15:12 GMT

Create and specify separate bookmarks for each of the pages you want to export with the applied filters.

Re: Power BI REST API: Problems exporting multi-page reports with bookmarks

Anonymous — Wed, 30 Dec 2020 07:43:55 GMT

Thanks for the suggestion. That should work, although it'll become onerous for reports with many pages.

Just to confirm: the current behaviour isn't the intended one, or is it? In theory Data-only bookmarks shouldn't remember the current page. And the default bookmark for an export request should apply to all pages exported within the request.

I believe there formerly was a warning in the REST API documentation to the effect that identifying a bookmark by name didn't work yet, but the warning has since been removed.

Re: Power BI REST API: Problems exporting multi-page reports with bookmarks

lbendlin — Wed, 30 Dec 2020 14:29:36 GMT

My understanding of bookmarks is different (not necessarily correct 🙂 ) - I think of them as being locked to certain filter snapshots for a page.