Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to export Excel file from Power BI report server using URL

Hi All,   Is it possible to export a rdl report to Excel file using URL link?   Regards, Jimmy
Excel
rdl
  • d_gosbell's avatar
    d_gosbell
    6 years ago

    No, there are no changes to server settings required. Did you use the url format from the documentation link?

     

    eg.

     

    https://<server>/ReportServer?/<reportfolder>/<reportname>&rs:Format=PDF

     

    Note that you need to use the Webservice url (/reportserver by default), not the portal url (/reports by default)

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks for your resply.

 

Is there any setting needed in the server setting, I have added the paraameter but it did not work.

d_gosbell's avatar
d_gosbell
Super User
6 years ago

No, there are no changes to server settings required. Did you use the url format from the documentation link?

 

eg.

 

https://<server>/ReportServer?/<reportfolder>/<reportname>&rs:Format=PDF

 

Note that you need to use the Webservice url (/reportserver by default), not the portal url (/reports by default)

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi,

     

    Many thanks, it works now. Despite the web service url, the folder does not need to include the <home> folder.

     

    Jimmy