We recently announced the ability to schedule PDF attachments for Paginated Reports in Power BI (https://powerbi.microsoft.com/en-us/blog/e-mail-subscriptions-for-paginated-reports-is-now-available/).
We’re planning to have this ability for Power BI reports as well, but it will take time to put that feature in place.
For folks asking about the ability to print/export the entire table of data to PDF or other format, we’ll be announcing shortly the ability to publish paginated reports using Power BI datasets, which would allow folks to create simple paginated report tables to use for this scenario, as it’s not currently possible to do this with Power BI reports natively at this time.
Here is our use case:
We have numerous SSRS reports and we've thought that Power BI would be a lovely replacement for most of them. So, with that in mind, we've developed several Power BI reports and using a mix of the matrix visualization and where appropriate, added line charts, scatter plots, bar charts, etc.
Nearly all of the .pbix files incorporate slicers because the same report can be used for multiple locations. However, the users at each location only want information for their location, which means I either have to replicate a report page for each location, or force them to use the filters so that I can minimize the time I spend on report maintenance & design.
My customers spend about 90% of their time away from their desktop machines/laptops, yet they would love to be able to access management reports and graphics when they are away from the desk. Mobile app offers cool capabilities, but not really enough "screen real estate" to properly convey these matrix report.
And, of the 10% of their time spend at the desk is critical and my users have expressed disinterest in navigating power bi service to hunt for a report page, filter it... and then try to print (WHICH ISN'T AVAILABLE TODAY).
What would be optimal is for me (analyst/report writer) to develop a single report which uses filters so that I can maximize my time. Second, if you provided the capability for someone (end users or an administrator type role) to schedule a report which would include all the filter parameters to be generated from Power BI and have it delivered to one or more recipients' email.
Perhaps think of it like calling a stored procedure with the passed parameters and having that report kicked out to an email address. I'm always happy to collaborate on this subject. We might not drive added users onto Power BI, but gosh, it's they way many of my internal customers want to manage their day.
My internal customers -- the ones making decisions using the data -- almost demand that data be pushed to them because they don't sit in front of a computer.
I've created R visuals using ggplot primarily because of limited range of capabilities in Power BI's scatter plot. And furthermore, we've only attempted to leverage the "subscribe" feature as a workaround to the lack of printing capabilities.
If Power BI supported passing parameters in the URL to the report, I would be less concerned with supporting custom visualization in the subscription feature.
The real value and need is the Power BI user needs to clearly see the full report (filtered to their liking). It could be an attachment in their email, or a URL link to a printed version of the report. It should not be a link to the existing Power BI report page because they want to see only the data, not the wireframe around the report, nor all the other filters, etc.
For example, I have matrix visualizations containing the following columns in the VALUES: date, supplier, location, quantity, and cost. In the ROWS I have: manufacturer, product, and purchase order#.
I'd prefer the PO# to be a value; however since it's multiple POs for each product, I only get one PO if I show this as a value.
My subtotals are lovely for quantity and cost, but I also get a subtotal value for location & supplier... and that's just plain confusing.
Granted, I could move these categorical factors to a ROW, but then the row count in the matrix explodes and the report is not really functional.
Vote both, perhaps?
I'd like to apply polynomial trendlines to charts. Currently doing this in an R visual & ggplot, but I would like to see this native to Power BI line and line/column cluster charts.
Great idea! We’d like to add more visualization types in the future, and the votes that this item receives will help us prioritize them.
Seems this idea is similar to accommodating a date as an axis in a scatter plot. In my estimation, there are numerous ideas related to scatter plots and dates on the axis... don't work like they do in Excel. I would like to see all issues related to scatter plots & date on the axis aggregated and addressed as a whole. I think the perceived problem and demand from the voice-of-customer is larger than this single item.