render paginated report in desired format automatically

[Anonymous]

How can i render paginated reports present in the powerbi workspace as an automated process?

I am currently having some SSRS reports in hosted in azure report server that i am programatically executing and rendering in .mht format to be embedded in email body using C#.I use report server web service API and report execution endpoint to do this.However,now i have another requirement where there are some paginated reports in the powerbi service and not sure how to do the redering.I did see some results stating powerBI REST API to be used but i am not sure if that is the way to go.Can someone pls detail as to what is the approach and process involved for paginated reports.

[lbendlin · Accepted solution]

Yes, the REST API is the expected way for you to do that. Buckle up, it's quite a process.  You need to request the render, then poll for rendering status and then when rendering is complete, pull the result down.

Note the supported formats for paginated reports. 

FileFormat

Export to file format

FILEFORMAT

Name	Type	Description
CSV	string	Requested file format is CSV (only supported for paginated reports)
DOCX	string	Requested file format is DOCX (only supported for paginated reports)
IMAGE	string	Requested file format is IMAGE (only supported for paginated reports)
MHTML	string	Requested file format is MHTML (only supported for paginated reports)
PDF	string	Requested file format is PDF
PNG	string	Requested file format is PNG (only supported for Power BI reports)
PPTX	string	Requested file format is PPTX
XLSX	string	Requested file format is XLSX (only supported for paginated reports)
XML	string	Requested file format is XML (only supported for paginated reports)

[PowerBIOrg]

Hi,

By any chance, do you know what is the Render Format for Accessible PDF? PDF doesn't work for it. 

[lbendlin]

Should be ACCESSIBLEPDF

[Anonymous]

Thanks for confirming.