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

[jimmywhc]

Hi All,

Is it possible to export a rdl report to Excel file using URL link?

Regards,

Jimmy

[jimmywhc]

Hi Guy,

I discovered that if I used rs:format parameter to export as Excel file, the file format is different from the one that I selected from menu bar. Did anybody have idea, please help?

Regards,

Jimmy

[d_gosbell]

---

@jimmywhc wrote:

I discovered that if I used rs:format parameter to export as Excel file, the file format is different from the one that I selected from menu bar. Did anybody have idea, please help?

---

What sort of differences are you seeing? There is only one Excel rendering engine in the product, in theory the menu bar option is just calling in to the rs:format=Excel url endpoint.

[jimmywhc]

When I export the file with rs:format=EXCEL parameter, the file extension is '.xls'. However, if I export using menu bar, the file extension is '.xlsx'. Although they still can be opened by MS Excel program, I want to know if there is a possible solution to export in '.xlsx' by either way

[d_gosbell]

---

@jimmywhc wrote:

When I export the file with rs:format=EXCEL parameter, the file extension is '.xls'. However, if I export using menu bar, the file extension is '.xlsx'. Although they still can be opened by MS Excel program, I want to know if there is a possible solution to export in '.xlsx' by either way

---

Ooh that's really bad. There is an option missing from the documentation for rs:Format=EXCELOPENXML which is what you need to use to generate XLSX files. This should fix your issue and I've left a comment on the documentation page so hopefully microsoft fix this omission.

[jimmywhc]

Thanks.

[d_gosbell]

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

[jimmywhc]

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 · Accepted solution]

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)

[jimmywhc]

Hi,

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

Jimmy