topic Re: exportToFile API: Exporting a single visual to file with Bookmark attribute in Developer

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

Anonymous — Fri, 16 Dec 2022 20:18:30 GMT

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-limitations

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

v-jianboli-msft — Mon, 19 Dec 2022 03:30:48 GMT

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.

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

Anonymous — Mon, 19 Dec 2022 17:01:58 GMT

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.

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

v-jianboli-msft — Tue, 20 Dec 2022 05:59:14 GMT

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.

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

AmosHersch — Tue, 20 Dec 2022 07:06:07 GMT

@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

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

Anonymous — Thu, 29 Dec 2022 18:53:15 GMT

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

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

toltmanns — Tue, 31 Jan 2023 17:13:36 GMT

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.