Forum Discussion

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

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)

Super User

6 years ago

Yes, you would just add the rs:Format=Excel url parameter. There are a bunch of different url access parameters that you can use see https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-server-ver15

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
  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
    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