Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
klinejordan
Advocate II
Advocate II

Export To File API specific pages

I am trying to build the Body of a HTTP call to export a non-paginated report to PDF. The simple body just specifying the format works without issue:

{
"format": "PDF"
}

 

But when I try to add references to specific pages, it works but still exports the entire report and not just the pages I specify. Am I missing something in the syntax?

 

{
"format": "PDF",
"powerBIReportExportConfiguration": {
"Pages": ["ReportSectiona9e3231081c009928308","ReportSectionff5f4406621243856c08"]
}
}

1 ACCEPTED SOLUTION

You take the output of Getpages and modify it as needed.

 

 

 

{
	format: "PDF",
        powerBIReportConfiguration:{"value": [
    {
      "Name": "ReportSection59a3330f95669ad473e6",
      "displayName": "1 Summary",
      "order": 0
    },
    {
      "Name": "ReportSectionc587b2defc60bdd51b80",
      "displayName": "2 Weekly FY20Q3",
      "order": 1
    }
   ]
  }
}       

 

 

 

EDIT: No, that didn't work it still exported the entire set of pages.  Here's the format that actually works

 

 

{
	format: "PDF",
        powerBIReportConfiguration:{pages:[{pageName:"ReportSection59a3330f95669ad473e6"},{pageName:"ReportSectionc587b2defc60bdd51b80"}]}
}   

 

 

So you were pretty close 🙂

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

Yes, the call expects a different format

 

Selecting which pages to print

Specify the pages you want to print according to the Get Pages or Get Pages in Group return value. You can also specify the order of the pages you're exporting.

Thanks @lbendlin but do you have an example of the syntax? I see that reference to Get Pages but not sure how to translate that to a JSON body in an HTTP call. Thanks!

You take the output of Getpages and modify it as needed.

 

 

 

{
	format: "PDF",
        powerBIReportConfiguration:{"value": [
    {
      "Name": "ReportSection59a3330f95669ad473e6",
      "displayName": "1 Summary",
      "order": 0
    },
    {
      "Name": "ReportSectionc587b2defc60bdd51b80",
      "displayName": "2 Weekly FY20Q3",
      "order": 1
    }
   ]
  }
}       

 

 

 

EDIT: No, that didn't work it still exported the entire set of pages.  Here's the format that actually works

 

 

{
	format: "PDF",
        powerBIReportConfiguration:{pages:[{pageName:"ReportSection59a3330f95669ad473e6"},{pageName:"ReportSectionc587b2defc60bdd51b80"}]}
}   

 

 

So you were pretty close 🙂

That worked! I was almost there! Thanks again!

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors