Export selected pages to PDF using REST APIs

[vmakhija]

Hello All

I have created a MS Flow to export my report PDF using REST APIs.

I have used the following set of blogs to accomplish this -

https://blog.crossjoin.co.uk/2020/04/25/calling-the-power-bi-export-api-from-power-automate-part-1-c...

https://blog.crossjoin.co.uk/2020/04/27/calling-the-power-bi-export-api-from-power-automate-part-2-c...

However, I want to export only selected pages of my report to PDF. Does anyone know how do to this or have any ideas?

I found that we have an API to get the pages of the report -

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/getpagesingroup#code-try-0

However, I am not sure how to combine this with my Flow to select only certain pages.

Regards

[lbendlin]

you need to specify the requested pages in the request body

https://docs.microsoft.com/en-us/rest/api/power-bi/reports/exporttofileingroup#powerbireportexportco...

[vmakhija]

@lbendlin 

do you have a reference to any example or usage for this?

I am unable to understand how do I use this syntatically.

Regards

[lbendlin]

instead of just specifying the format you also add the pages you want.

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