topic Try to use rest API(Export to PDF) with Python in Developer

Try to use rest API(Export to PDF) with Python

lovepreet81988 — Mon, 24 Jul 2023 11:02:01 GMT

I am attempting to utilize the "export to PDF" with REST API query in Power BI, but despite using Power BI, I'm encountering difficulties in generating the PDF file.Please provide me solution to reterei data from reports

Re: Try to use rest API(Export to PDF) with Python

Anonymous — Wed, 26 Jul 2023 01:40:03 GMT

Hi @lovepreet81988 ,

You can refer the following links to get it:

Using Python:

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

POST https://api.powerbi.com/v1.0/myorg/reports/{reportId}/ExportTo

GitHub - AntoineDW/powerbi-rest-api-python: A Python library created to easily use the Power BI REST API with Python

pip install pbirest import pbirest pbirest.connect( client_id = [client_id (required)], username = [username (required)], password = [password (required)], tenant_id = [tenant_id], client_secret = [client_secret] )

Documentation · AntoineDW/powerbi-rest-api-python Wiki · GitHub

pbirest.export_report(workspace_id, report_id, out_file)

Using Postman:

How to use Power BI Rest API to export the Power B... - Microsoft Fabric Community

Best Regards

Re: Try to use rest API(Export to PDF) with Python

lovepreet81988 — Wed, 26 Jul 2023 09:08:36 GMT

hi @Anonymous

Upon attempting to use the POST method with the endpoint URL "https://api.powerbi.com/v1.0/myorg/reports/{reportId}/ExportTo," I encountered an error response:

{ "error": { "code": "InvalidRequest", "message": "Report requested for export is not on dedicated capacity" } }

can u please explain this why i am getting this error

Re: Try to use rest API(Export to PDF) with Python

Anonymous — Wed, 26 Jul 2023 09:22:49 GMT

Hi @lovepreet81988 ,

There are some limitations when using export to file API, it includes that the report you're exporting must reside on a Premium or Embedded capacity. So please check that your report is in a shared capacity or dedicated capacity...

Export Power BI report to file

Best Regards

Re: Try to use rest API(Export to PDF) with Python

lovepreet81988 — Wed, 26 Jul 2023 09:51:59 GMT

@Anonymous
Could you kindly guide me with a step-by-step guide on how to save a report in Embedded capacity?