Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Downloadins as PDF a report from report server

Hi all, My user want to download a report from Report Server (so not power bi services) to pdf. He can't do this by downloading the pbix and then export to PDF because the report use live connecti...
PowerShell
Report Server
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi, Anonymous 

You need to know the exact path or ID of the report you want to export. This can usually be found in the report server's web portal.

Power BI Report Server has a REST API that you can use for a variety of tasks, including exporting reports. While the API documentation may not explicitly cover exporting to PDF, it follows a similar structure to the SQL Server Reporting Services (SSRS) REST API, which supports PDF export. You can use the appropriate endpoint to construct a GET request to the report server URL to export the report.

Since you want to use PowerShell for this purpose, you can use cmdlets to make HTTP requests.

Process authentication: Depending on the configuration of the report server, you may need to process authentication. If your server uses Windows authentication, you may need to add parameters to your calls.

 

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous 

     

    Thank you very much for your answer.
    I am a beginner at PowerShell. I am indeed using REST API, but &rs:Format=PDF parameter doesn't seems to work even with the highest credentials.
    Let say the url to download my report as a pbix file is https://ServerName/Reports/api/v2.0/catalogitems(itemid)/Content/$value
    What to I have to change to download it as pdf ?

    Thank you in advance for your help.

    Regards,

    Alice