cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
whereismydata Regular Visitor
Regular Visitor

Export Pagianted Report via URL | Subscription PDF naming convention

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
whereismydata Regular Visitor
Regular Visitor

Re: Export Pagianted Report via URL | Subscription PDF naming convention

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'

 

 

1.JPG

 

 

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 

 

View solution in original post

3 REPLIES 3
Highlighted
bradsy Member
Member

Re: Export Pagianted Report via URL | Subscription PDF naming convention

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

whereismydata Regular Visitor
Regular Visitor

Re: Export Pagianted Report via URL | Subscription PDF naming convention

ah, ok. I'll give it a try.

 

Thank you

whereismydata Regular Visitor
Regular Visitor

Re: Export Pagianted Report via URL | Subscription PDF naming convention

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'

 

 

1.JPG

 

 

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 

 

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)