exportToFile API: Exporting a single visual to file with Bookmark attribute

[Anonymous]

Our team is trying to add export features to our embedded Power BI charts. Specifically, we'd like to use Bookmarks to save the states of single report visuals and export them with the given state. The exportToFile API enables exporting and downloading of a Power BI report by using a REST call. We've been successful with exporting entire Power BI Pages with the Optional Bookmark attribute, but currently there is no Optional Bookmark attribute available for exporting a single visual (see "Exporting a page or a single visual" within the Microsoft.com Reference link). The API also supports passing strings of Filters, however there are limitations like incompatibility with Slicer filters and NotIn operators within the filters query. Unfortunately, we use many slicers and the NotIn operator when constructing our filters.

Has anyone been able to use the API to export a single visual from a Page with Bookmark-like simplicity besides passing in filters?

Reference : https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to#considerations-and-limitatio...

[toltmanns]

Hello all,  I am picking up where @Anonymous left off.  

We are attempting to export a single visual passing in the Bookmark state to the ExportToFileInGroupAsync API method and the single visual seems to be applying the bookmark state even though the API example still indicates the bookmark state is not used in the single visual export.

Did something change to allow that functionality?  I see @Anonymous's idea is still in a new state.

[v-jianboli-msft]

Hi @Anonymous ,

If you would like to suggest some feature improvements. You could post your needs  here , people may vote the idea and comment  to improve this feature. It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-jianboli-msft]

Hi @Anonymous ,

According to my knowledge, there is no support for exporting individual visuals with bookmarks.

Bookmarks are used to save the current state of the entire report page, so it is not possible to select bookmarks when exporting a single visual.
You can try to keep only one visual object you want in a single report page and create a bookmark for that state, then export the report page.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thank you for the reply Jianbo!

That's a good suggestion about having single charts on a report and applying bookmarks and exporting from there. However, we do have multiple Power BI files with singles pages made up of multiple visuals, so that solution isn't feasbile at scale.

Yes, we are aware it's currently not possible, but were hoping Power BI would introduce this ability to export a single chart with a bookmark applied at some point. Alternatively, we hope they can add support for Slicers filters and the NotIn operator for passing filters into the URL for exporting single charts.

[AmosHersch]

@Anonymous did you try to call the API with the optional pageName + visualName attribute ? It should export a specific visual.

Then if you add also the bookmark I believe it should export the visual with the bookmark applied

[Anonymous]

This did not work us when we tried, but thank you for the suggestion! If this is something you would like to see (or anyone else viewing this thread), please vote on our submitted Power BI Idea: https://ideas.powerbi.com/ideas/idea/?ideaid=c8dadd7f-7c7d-ed11-a76e-281878bd14b2