cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

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

Accepted Solutions
Highlighted
Super User V
Super User V

Re: Export To File API specific pages

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
Highlighted
Super User V
Super User V

Re: Export To File API specific pages

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.

Highlighted
Frequent Visitor

Re: Export To File API specific pages

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!

Highlighted
Super User V
Super User V

Re: Export To File API specific pages

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

Highlighted
Frequent Visitor

Re: Export To File API specific pages

That worked! I was almost there! Thanks again!

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Kudoed Authors