topic Re: PowerBi - Rest API - Reports - Export To File using bookmarks in Developer

PowerBi - Rest API - Reports - Export To File using bookmarks

ResAPIToTheMoon — Tue, 18 Feb 2025 10:06:45 GMT

Dear community,

I am desperately trying to export a Power BI file, which is located in a Fabric environment, to a PDF using the REST API. The PBIX file contains a single page. This page has five bookmarks applied to it, each filtering the data based on a specific country.

Our goal is to reference each of these bookmarks and export them individually as PDFs, all based on the same report page. This works, for example, in Power Automate when I loop through the bookmark names extracted from the URL after publishing.

However, when we try the same approach in a Python notebook within Fabric, only the first page is exported, even if we explicitly specify a different bookmark.

Below you can find relevant code:

# Define the payload (body) for the export request

payload = {

"format": "PDF",

"powerBIReportConfiguration": {

"Bookmarks": {

"name": bookmark_guid

}

Re: PowerBi - Rest API - Reports - Export To File using bookmarks

lbendlin — Wed, 19 Feb 2025 01:24:02 GMT

Have you tried the API call in the sandbox? Make sure your payload has the right format.

Re: PowerBi - Rest API - Reports - Export To File using bookmarks

ResAPIToTheMoon — Wed, 19 Feb 2025 08:16:39 GMT

The payload was not correct. This one works:

payload = {

"format": "PDF",

"powerBIReportConfiguration": {

"defaultBookmark": { "name": bookmark_guid }

}

Re: PowerBi - Rest API - Reports - Export To File using bookmarks

Anonymous — Thu, 20 Feb 2025 02:58:34 GMT

HI, @ResAPIToTheMoon
We are very pleased to hear that the issue has been resolved. Thank you for sharing the solution with us. If you are willing, you might consider accepting this solution, as it can also help other community members facing the same issue find a solution more quickly.

Of course, if there is anything else we can do for you, please do not hesitate to contact us. Once again, thank you for your contribution, and we look forward to your response.

Best Regards,

Leroy Lu