Export To File for Power BI Reports with multiple bookmarks and recipients

[Vincentvillerey]

Hello everyone,

In the same workflow, I would like to send, for example, 5 emails to 5 recipients using the action "Export To File for Power BI Reports" with a bookmark so each recipient gets a customized data report. However, each time I used that action, they each received the same data report. I used the dynamic variable, named "content file" (see screenshot), but I haven't been able to send a customized data report to each recipient.

Could you please help me identify a solution?

[bchager6 · Accepted solution]

You need to specify the page and bookmark name within the Export To File for Power BI Reports step like so:

[Vincentvillerey]

Thank you @bchager6 !

My mistake was to use "bookmarkGuid=Bookmark...." instead of "Bookmark...". I will pay more intention in the future to little details.

Have a good day 🙂

[bchager6]

@Vincentvillerey  can you please let me know if this works for you? I would also like to figure out how to export a specific visualization, but am not finding any documentation on how to do that.

[Paragadi]

Hi,

I tried it myself and i keep getting the ppt without the bookmark

[bchager6]

@Paragadi  Are your bookmarks grouped together? It didn't work when mine were grouped together.

[Paragadi]

Hi.

My bookmarks weren't grouped

[Paragadi]

i put 2 items for two pages with one bookmark and i get  the same page filtered twice.

duplicate of the first page filtered correct

[Diego_Pio86]

Eu estou com mesmo problema.

[melsaadawy]

Hi 

I am following the same steps but I got this error any idea what is the reason 

Thanks

[Vincentvillerey]

Yes @bchager6, it's work. Thank you very much 😉 !!!

[Vincentvillerey]

Hi,

I'm not to understand you very well, but the philosophy is following: for each export, you have to use one PageName with one BookMark. You cannot use one PageName with another BookMark twice on the same export ; if you want to use a similar PageName, you can duplicate it on Power BI Desktop and get PageName and its BookMark.

Is it better now? 

[melsaadawy]

I am using a one-page name with one bookmark but it gives me an error message when I run the workflow "Export report with page names which does not exist in the report is not supported" However I copied the correct page name from the Power BI URL 

[Vincentvillerey]

Hi @melsaadawy ,

It seems you have to be perfect with id of PageName and BookMark, look better chain character ; like this :

Have a good day

[RobertBotan]

Hi,

Can someone help me with the following issue that I'm facing. I have a report in Power BI that's refresh every day. I'm interest in sending the mail based on the 19 value when it changes. So I created a metric in Power BI that tracks that value and when it changes I should receive the mail (logic) but I'm not receiving any email.

This is how it look like in power Automate