Skip to main content

Notifications

Power Automate - General Discussion
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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?

  • harpyboy Profile Picture
    harpyboy 9 on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

    cool. yes working normal now. 

  • jmerdman Profile Picture
    jmerdman on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

    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.

  • jmerdman Profile Picture
    jmerdman on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

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

  • cqhui Profile Picture
    cqhui 4 on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

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

     

  • jmerdman Profile Picture
    jmerdman on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

    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.

     

  • harpyboy Profile Picture
    harpyboy 9 on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

    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. 

  • jmerdman Profile Picture
    jmerdman on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

    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

  • RachelGomez123 Profile Picture
    RachelGomez123 31 on at
    Re: Export to a File for Power BI Reports - Using Bookmark Name - No longer working

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,636

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,942

Leaderboard