Will PageBookmark property take priority over ExportFilters property?

[alohaes]

Hi everyone. I am exporting a powerbi report using exporttofileasync method and passing the captured state of the report and a my list of filters to PageBookmark & ExportFilter properties respectively. But, the thing is I need to test if my export filters will apply over the state so while debugging I am changing the export filter to something else(but valid one) then resuming the flow to call the export method from the SDK. And, I don't see my export filter getting reflected on the exported report(on data and visual level both) but only the captured state of the report.

Does the bookmark state take priority over the export filters while exporting a report?

Thanks for the help!

[v-shex-msft]

HI @alohaes,

Did these filters already saved to the report or only operate on the 'read view' mode report? AFAIK, the export file API will interaction with saved filters.
If these filters are applied on read view mode, I suppose the saved bookmark should has higher priority than these read only mode filters.

Regards,

Xiaoxin Sheng

[alohaes]

Hi thanks for the reply and sorry for late response. By saved filters I assume you mean the filters that are designed by the report author, if so then yes. The report in question has a date visual which I am trying to apply while exporting the report using DAX. And the bookmark is not saved I guess(I assume you mean the bookmarks made by author himself), I am capturing the state of the report using the capture() from PowerBI JS SDK.

Please let me know if this information relates to your queries or not. Thanks for the help!

[v-shex-msft]

HI @alohaes,

AFAIK, Bookmark is used saving specific filter effects, you can use it to quick replace and restored the current filter effect to saved versions.

In addition, if you both use the bookmarks and common filters, the after one effect will override to the previous filter effects.

Regards,

Xiaoxin Sheng

[alohaes]

Hi, thanks for the reply. Even I assumed so and I made a small dummy project to check this out and its working as you mentioned. My filters are applying over the bookmark in the exported report but the weird thing is that in our prod application the same is not happening. The report gets exported with only the captured bookmark state and not our exclusive filters we are passing in the API. Even though the code and logic to capture the bookmark state and exporting the report is same as the POC.

Though, the only difference is that the bookmark state being passed in our prod is first being encoded again into a base-64 string and then decoded back before making the export call. But even that doesn't have any impact on the POC export when I pass the state as hardcoded there.

Is there any other property on PowerBI JS or PowerBI API SDK that we need to set when exporting report so that it takes the export filters over the bookmark state?

Thanks for your help!