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.
Last request around this, having the option to execute the subscription according to other refresh. For example, we are using a scheduler but this is already impossible to administer the PBI dataset refresh properly and schedule the launch of the report just after.
Only current workaround: knowing the average time required for the dataset to refresh, taking some marging and planning the launch of the reports afterward. But in case of dataset refresh error or dataset refresh that took more time than expected, all report will have the incomplete figures of not totally wrong.
All this to be able to use PBI as a whole on a global and WW scaled company instead of on-premise platform to avoid all these missing functionalists
it could be useful to have the subscription report using the RLS of each individual user we are sending the report and not only according to the security of the subscriber (ie: I am an admin that setup a subscription and which the users to only receive the report according to their rights).
It could also be useful to have secured images on on-premise servers that are exported in PDF or other properly. currently it s an error box !!!
Hi Team, similar to other reactions, i was simply amazed to find out that subscriptions currently only deliver .png format (for PBI Pro users). Other BI tools can export to pdf/excel/csv/html... It's really a step back for a user community that is used to features like that.
I see your latest update dates July 16, 2019. Would you have more news in the meantime? Thx.
This is just basic functionality that everyone else has. You shouldn't have to purchase a list of SKUs beyond that of what is supposedly a 'power' app. Automating a .pdf, .csv, .xlsx file should, at the very least, be an option. These are basic file types that many use every day. I get it if the free version didn't have this very basic functionality. But, once you charge someone for something like this, to exclude this very basic functionality is ridiculous. especially when you call it a 'power' app.
Is this in Premium or Service?
I think MS will not implement ths in a way people reading this expect as this breaks the business model. Allowing automated export to pdf/powerpoint etc means consumers would not need a powerbi license. Why else cripple the product like this? If you need this, you may want to look at another bi sollution. But I added my vote!
It would be nice to export data to Excel or csv, not onlyvodf
will this new version will allow to send report by an admin to a list of groups with RLS?
Will the image on secure on-premise servers will be show on the PDF export (currently not the case when we do a PDF or PPT export) where our images are only available when using PBI service or desktop
will you also fixed the issues on the current version of the scheduled report that do not show the current available data or sometimes just blank components?
I have tickets open on the premium support already since months without fix
Rui Barbosa commented
We love PowerBI so much and we know the team is very busy making it so awesome, that at DevScope we extended it a little bit with Powerbi Robots.
Powerbi robots automatically creates Hi-Res PDFs of PowerBI dashboards and reports and sends them anywhere, scheduled when you want it and to an unlimited number of recipients.
ª Automate Power BI reports
* Send Power BI reports to anyone
* Filter data delivered by audience
* Display Power BI reports anywhere (email, pdf, tvs,devices)
More info at : https://www.powerbitiles.com/?app=PBIRobots
Thank you PowerBI Team.
Fransiskus Memet commented
i vote for scheduled export of a report to excel file
Brian Connelly commented
While completing this, it would be nice to have the URL filters respected when you choose Current Values for your exported.
We also need to automate exporting visual data to csv. Our report has scrollbar, export to pdf shows only a small portion of the data.
We started with PowerBI Pro and didnt even think about having this function; we thoughts thats absolutely standard - ecspecially if you guys call it the "Power Platform" with Automate and so on.
Its unbelievable, that an automatic export to csv and then mailed / moved on to ftp, onedrive whatever is not possible. This is an showstopper for us and - if we cant find any 3th party solution - we have to move on to another BI solution. I really dont understand how you guys could "forget" this feature.
Philip Bowen commented
Scheduled exporting of data from Power Bi in Excel will be highly beneficial, especially when connecting to two or more data sets is not possible. Information from one report using a data set could be easily incorporated into another report if this export was automated.
Please consider adding this feature.
This will be really beneficial as people are looking for a "hard copy" file that can be run before an automated update for audit reasons.
Is there any timeline when this will be released
Kiran Hosakote commented
At BI Helper https://bihelper.tech, we continue to build on the core ‘Export to PDF and email’ functionality for Power BI Pro, Embedded and Report Server users. New features in BI Helper:
1. Integration with Microsoft: Enhanced security and seamless interface with Power BI.
2. Matrix and Table Visuals as MS Excel files: See your matrix and table visuals in Power BI as MS Excel files, sent to you as email attachments. With support for full vertical and horizontal scrolling, so that you can easily view ALL your data. With report filters and slicers applied, so you can view ONLY your data!
3. Support for custom Canvas (page) sizes: Build your Power BI reports with any canvas size and aspect ratio. Use BI Helper to automate PDF creation and report distribution.
Visit https://bihelper.tech for a demo.
we need excel or csv
Brad Martin commented
We're using Power BI as a lightweight ETL tool to perform transformations on data from various sources, but need to be able to automatically export the transformed output. Power Automate would be a perfect end-to-end solution if we could just export the data from Power BI automatically.