Forum Discussion
render paginated report in desired format automatically
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.
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)
4 Replies
- lbendlin
Super User
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)
PowerBIOrgResolver II
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