Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi 🙂
we use an on-prem power bi reporting server for hosting our reports. I've created some paginated reports with subcriptions, eg. export every month to windows file share. Only issue I have is the naming of the pdf file. Every month the pdf should be named like "report_month_year.pdf" I did not find any sufficient solution - all I found was to ad '@timestamp' to create a timestamp. But this is not working for me since I export the report not in the same month as the data shown in the report.
During my research I stumbled upon export a report via URL. Since I use MS Flow quite a lot I was wondering if I could build a flow which downloads the pdf and then also renames it (I know, I also could export the pdf via subscription and then rename it with flow)
And here is my problem:
https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?view=sql-serv... says the syntax for exporting is:
https://myrshost/ReportServer?/myreport&rs:Format=PDF
with the example:
https://servername/ReportServer_THESQLINSTANCE/Pages/ReportViewer.aspx?%2freportfolder%2freport+name+with+spaces&rs:Format=pptx
I access our reporting server by this domain:
http://ourserver/Reports/browse/
When I try this nothing happens, I just get redirected to the favorites pane:
http://ourserver/Reports/Pages/ReportViewer.aspx?%2freport%2fPaginated%20Reports&rs:Format=PDF
So I guess I have two questions:
1) is there a solution where I can handle naming in the subscription menu (or in the sql job)
2) what's wrong with my link?
Hope someone can help me. Thank you very much!!
Solved! Go to Solution.
Hi,
I did find the error; I got confused with the folder in the syntax.
Paginated Reports are uploaded into the the 'folder' 'Paginated Reports'
and looking at the destination I thought I have to use the folder 'report' as well.
http://server/reports/browse/report/Paginated%20Reports
but instead I just have to use the filename; apparently this folder is not a real folder
http://server/ReportServer/Pages/ReportViewer.aspx?%2fPaginated+Reports&rs:Format=PDF
Hi,
I did find the error; I got confused with the folder in the syntax.
Paginated Reports are uploaded into the the 'folder' 'Paginated Reports'
and looking at the destination I thought I have to use the folder 'report' as well.
http://server/reports/browse/report/Paginated%20Reports
but instead I just have to use the filename; apparently this folder is not a real folder
http://server/ReportServer/Pages/ReportViewer.aspx?%2fPaginated+Reports&rs:Format=PDF
Hi,
I had the same problem and would like to download the paginated report by url. And it did not work, do you have the solution for that? Thanks.
Regards,
Jimmy
Hi @jimmywhc
I posted my solution above, but in short:
just attach the filename of the report to the url of your report server.
http://server/ReportServer/Pages/ReportViewer.aspx?%2fPaginated+Reports&rs:Format=PDF
The http://server/reports directory is for the hosted front end. If you want to use the API to access the reports, then use the reportserver folder, http://server/reportserver
ah, ok. I'll give it a try.
Thank you
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
6 | |
4 | |
3 | |
2 |
User | Count |
---|---|
13 | |
10 | |
5 | |
4 | |
3 |