Unable to export the report as PDF or image file using SPN through API call

[Anonymous]

Unable to export the report as PDF or image file using SPN through API call. Getting 403 forbidden error.

https://api.powerbi.com/v1.0/myorg/reports/61b208a4-8780-4dfc-80ea-474b19d107af/ExportTo

BODY: {"format": "PNG"}

PNG, PDF, CSV none of it worked.

403 Access forbidden to use export API.

But as a user we can do.

[Anonymous]

Anyone can tell if the SPN can do this activity? User is able to export the report to Image files. If we add SPN in the admin setting its not working.

[v-yiruan-msft]

Hi @Anonymous ,

Please review this official documentation and check whether the related setting for service principal has been configured.

• Create an Azure AD security group and add service principal into security group
• Enable the Power BI service admin settings.
• Add the service principal to your workspace.

In addition, please note that the report with a sensitivity label cannot be exported to a .pdf or a .pptx using a service principal. Also when exporting to .png is not supported.

Limitations

Best Regards

[mohammedadnant]

Hi @Anonymous 

If you are looking for out of the box solution, then I prefer you to go with Power Automate

check this video to know in detail

https://youtu.be/N2Djm1FH2-A

Thanks & Regards,

Mohammed Adnan

Learn Power Plaform using my Youtube Channel TAIK18 click on the name

[Anonymous]

How do you say that it is an out of box solution. There is a setting in Power BI Admin portal, Export to Image, PDF word. It works for users. Should it not wor for SPN registered as admin of embed capacity workspace?

[Anonymous]

The report is in embed capacity