Unanswered

Export to a File for Power BI Reports - Using Bookmark Name - No longer working

(0) Share

Report

Posted on by jmerdman

I've been using the same flow for months without any issues. It was exporting multiple pages which were not hidden and we were using the Bookmark Name field to only show 1 clients data versus another's. As of 8/16/2022, when we receive the pdf attachment via email it will show all 5 pages but it repeats the 1 pages content on all 5 pages. When I remove the Bookmark Name from the flow it works as expected however it is not filtered to only show the data via the Bookmark. Has something new happened this week to cause this issue?

Categories:

General topics

I have the same question (0)

All responses (8)

Answers (0)

RachelGomez123 31 on at

Like (0)

Report
Copy link

Link copied!

Hello,

We were able to fix the issue.
We upgraded powerbi-client npm package from 2.8.0 to 2.14.1 and we are sending in the bookmark state alone when calling ExportToFileInGroupAsync.

It is not clear why before 2020-10-07 exporting worked as intended when we sent in both BookmarkName and BookmarkState and now it only works with BookmarkState alone.
It is not clear why the bookmark state alone generated by version 2.8.0 of powerbi-client does not work while the bookmark state generated by 2.14.1 works.
An explanation/documentation update would be appreciated.

It would make debugging issues like these a lot easier if the return value from GetExportToFileStatusInGroupWithHttpMessagesAsync would contain details about the cause of the failure.

Regards,
Rachel Gomez

Was this reply helpful? Yes No
jmerdman on at

Like (0)

Report
Copy link

Link copied!

Hi Rachel,

I'm new to using Power Automate to export of Power BI reports using bookmarks so I'm not sure what bookmark state is and what data goes into that field for Power Automate. We were only using the bookmark name field and it was working fine until last week. I'm also not sure what you meant about "GetExportToFileStatusInGroupWithHttpMessagesAsync". We did not get a failure we just noticed when opening up the pdf page that it had the first page basically copied for each tab/page. Any help is greatly appreciated so we can get this fixed. Thanks

Was this reply helpful? Yes No
harpyboy 9 on at

Like (1)

Report
Copy link

Link copied!

I confirm I am observing the same behavior starting after the last weekend. It was working fine before.

I have a Power BI report in a premium capacity, with bookmarks for different filter settings. A Power Automate flow is created to export a PDF version of the reports, using different bookmark name, so that I can email different data to different users. The problem now is that whenever a bookmark name is used, the 2nd page and onwards became duplicates of the first page (bookmark is applied correctly though). And for testing, I remove the bookmark name from the flow, and the entire reports print to PDF correctly.

Something changed recently, and broke something.

Was this reply helpful? Yes No
jmerdman on at

Like (0)

Report
Copy link

Link copied!

Thank you harpyboy, hopefully someone can advise what the issue is so we can get it fixed. Please let me know if you hear anything. I will do the same.

Was this reply helpful? Yes No
cqhui 4 on at

Like (1)

Report
Copy link

Link copied!

It is back to normal now. I had a report set up for every couple hours and can observe the fix happened around Sunday.

Was this reply helpful? Yes No
jmerdman on at

Like (0)

Report
Copy link

Link copied!

Awesome news, I just checked as well and out Sunday reports are running as expected as well.

Was this reply helpful? Yes No
jmerdman on at

Like (1)

Report
Copy link

Link copied!

I was just informed that it looks like a fix happened on Sunday as the reports are now running as normal. Hope your reports are working as expected as well.

Was this reply helpful? Yes No
harpyboy 9 on at

Like (1)

Report
Copy link

Link copied!

cool. yes working normal now.

Was this reply helpful? Yes No