scheduled export of a report to pdf
It would be nice if there is an option to have a scheduled export of a report to PDF. A nice to have feature would be to directly e-mail it to people so they are being notified of the latest report.
Another update on this item – users now have the ability to set up scheduled subscriptions with paginated reports and 6 different formats, along with parameters per subscription to allow further personalization. There is also now the ability to create paginated reports against any Power BI dataset in the service, and we’re planning to add drillthrough from Power BI to Paginated Reports in the short term.
We still have plans to support e-mail attachments for Power BI reports as well in the coming months, and we’ll share more specifics once we get closer to starting that work.
Daniel (Australia) commented
Please see Tableau's print to PDF capability as a baseline. You can add borders, headings and footers. Essentially, people want to be able to print out PDF's for board meetings, which have to be in a specific look and format. The more customisable the better. Today, people have to export data out of PowerBI into Excel OR grab screenshots to reformat a page layout which defeats the purpose.
Hi Sirui. Our requirement is to be able to export a report, e.g. after the user has applied any filters, etc as a 'dumb' page. That is to say the report runner controls the selection of data, filtering etc and then outputs to a format like PDF so that it can be emailed to users inside and outside the enterprise.
A common use case is to meet statutory reporting requirements. E.g. our client have to report to central govt on a weekly or monthly basis with a report having fields X, Y and Z. Field length, etc being prescribed as is the file format.
In our case we are looking to save complete reports to PDF but presumably the ability to save a sub-set of pages would be valuable also.
We provide with PowerBi a Monitoring Service to our clients. We would like to send the reports (multiple pages in the same report) trough automated email (for example 1 time per week) to multiple people (our clients.).
We would really appreciate that.
Thank you for putting this under review - with our current BI system we can arrange for a "broadcast" of a report which sends a PDF version via email to the recipient. This way the execs don't have to log into BI and can get instant information.
Hi Sirui! I'm so happy that this feature it's under review. From my standpoint, I would like to be able to do a simple function of "Save As". It could be a page or the entire report. Part of this request is also to be able to "schedule in the future" the report to run and send via email as PDF.
Grant Wittenberg commented
We simply require the ability to change a filter on a multi-page report. Then, print a selected number of pages to PDF.
Dave O'Reardon commented
Use case: Each month I have to send a PDF report (one page) to a number of people. That report has a Business Unit filter. I need PowerBI to cycle through all the values of the Business Unit filter and produce a PDF for each Business Unit. I then email each PDF to various people who work in that Business Unit.
To do this now I have to do these steps 30 times, one for each Business Unit:
1. Change the filter value
2. Take a screenshot of the page using Snipping Tool
3. Print to PDF
4. Attach to email & send to recipients for that Business Unit
It'd save me a huge amount of time if PowerBI could do 1-3.
Multi-page reports export is super, super important here. Otherwise, it will be just like printing a dashboard and sending it to a PDF file printer. The ability to specify your filters is important too.
Dr G commented
Love that you are looking into this. I'd like the flexibility of choosing which pages to make a pdf as we have in MS Word. Slicers and filters etc should be based on what we are looking at when set the schedule...i.e. it pdfs what we see. Also would like the ability to scale each page so it fits on the selected page size.
I would generally just need a page of a report though being able to do all pages would be great, having the filters/slicers is critical. Being able to do a dashboard may be important, we haven't rolled out the contract for Service yet so right now I'm just doing the free version.
I would like the ability to export a PBIRS report to PDF on a network shared drive with one report page to one PDF page. No slicers or interactivity would be required in the output, but I do require the ability to set at least the report level filters when setting up the schedule.
The email to users feature is actually more important/useful than saving to a file share for my user base, so if it could work just like SSRS subscriptions that would be ideal.
The ability to data-drive subscriptions would also be ideal, for example such that each Power BI report can be filtered for each division in a list and then emailed to specific users for that division.
We need full report(multipage reports) exporting to pdf via API. If it possible?
Provide the option to select what you want to export just like when creating an app. This would allow you to select any combination of dashboards, reports, or individual pages of a report. Also, provide the option to toggle display of the filter/slicer states.
Allow the export to be on-demand or scheduled
Allow the printing of an entire table/matrix.
Be able to export entire pages/tabs. Allow to choose what slicers and filters and then export in that view.
Mehul Ahluwalia commented
Hi thank you for responding. Yes being able to export the whole report into PDF will be great. As powerbi is a SW people who do not have access to it are unable to view the report and therefore request for PDFs which lets them access the content without having to download the SW. You can also add the functionality of printing the reports which can help exporting to PDF.
I would begin with a PDF that corresponds to the report bookmarks.
In my case, we expand the table data in a report to full screen and want to export all the data to PDF. If you print -> saves as -> it gives only current page. I'm looking to export all of the data from that table to email or print. Any data not shown due to size you use a scroll bar but when I try to print or save as I only get the data currently shown on the page. My goal is to export multiple pages which includes all data from the table or matrix in a report to PDF.
Similar to what Deepa has requested.
Add this capability on Report Server
Jeff Shanahan commented
pagination to support printing all records from a matrix/table (full scroll down)
ray malone commented
Equivalent to SSRS