Forum Discussion
Save Pdf format of your report using Python
I would like to access to a report in powerbi server and save the report in pdf format in my PC using python, but I recived a message as
"the result should be passed only to trusted code in your notebook."
Here is the code I used:
import requests
from powerbiclient.authentication import DeviceCodeLoginAuthentication
# Authenticate and get the access token
device_auth = DeviceCodeLoginAuthentication()
access_token = device_auth.get_access_token()
group_id = "XXX-XXX-XXX-XXX-XXXX"
report_id = "YYY-YYY-YYY-YYY-YYY"
# API endpoint for exporting report to PDF
# Request headers
headers = {
"Authorization": f"Bearer {access_token}",
"Content-Type": "application/json"
}
# Request body specifying the export settings
data = {
"format": "pdf"
}
# Send POST request to export report to PDF
response = requests.post(url, headers=headers, json=data)
# Check the response status code
if response.status_code == 202:
# Get the URL for the exported PDF file
response_data = response.json()
download_url = response_data["downloadLocation"]
# Download the PDF file
response = requests.get(download_url)
# Save the PDF file to the specified path
pdf_file_path = "./report.pdf"
with open(pdf_file_path, "wb") as f:
f.write(response.content)
print("Report exported to PDF successfully.")
else:
print("Exporting report to PDF failed.")
2 Replies
Hello moonsarinalu
Did you get it to work?
I get an error on the linedownload_url = response_data["downloadLocation"]
Hello apenaranda
unfortunatelly not. I could never run it, and am thinking of using other solutions other than power bi to export reports.
