cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
tomepenn Frequent Visitor
Frequent Visitor

Print and/or export to PDF from PowerBI Embedded Report

Gentemen, we asked out partners about this in early 2017.  The answer was end of the year or maybe first quarter for the export to pdf feature.  We only have one basic workaroud by using window.print(), and insturcting our enterprise users to then print to pdf, which requires clicks and local pdf executables.  It isn't a solution we want to present.  

 

Does anyone have any news or an update form the engineering team?  Can someone that monitors this board please respond and/or reach out to Microsoft engineering team and ask for an update and reply here?  It is becoming a moderate to serious concern for a customer of ours planning significant launches in the near future.

 

Nimrod from the PowerBI team seems to be active on other PowerBI Embedded issues.  Maybe reach out to him?

 

Thanks for your help.

Tom

6 REPLIES 6
dom99 Frequent Visitor
Frequent Visitor

Re: Print and/or export to PDF from PowerBI Embedded Report

As far as I'm aware there is no functionality available which to me seems a hole in the eco-system seeing as the desktop has export to PDF, cloud service has export to PowerPoint, embedded has nothing.
Nonsensely Frequent Visitor
Frequent Visitor

Re: Print and/or export to PDF from PowerBI Embedded Report

I read somewhere that export to PPT would include all data in the report, but this is still the same screenshot with the data cut off, as exporting to PDF.  ARGH!!!  I just built several new dashboards to replace excel reports that my users have grown to love and depend on.  What a total waste!!!  

stuartb Frequent Visitor
Frequent Visitor

Re: Print and/or export to PDF from PowerBI Embedded Report

I've been banging my head against Power BIs inability to export natively to PDF for some time.

What we have done is to utilise AWS Lambda functionality to run Chromium into which we embed the report and save that to S3, served back to the customer as a download.

It's a faff, annoying, but works quite well 
https://github.com/sambaiz/puppeteer-lambda-starter-kit/blob/master/README.md


I'm pretty sure you could adapt this for Azure Functions too....
Might help 
Nonsensely Frequent Visitor
Frequent Visitor

Re: Print and/or export to PDF from PowerBI Embedded Report

Thank you Stuart!  

 

We do not run AWS, but I forwarded your response to my boss, who knows our systems and configurations.  It would be awesome to get this thing running!  

 

Regards,

Nancy

kk0036 Regular Visitor
Regular Visitor

Re: Print and/or export to PDF from PowerBI Embedded Report

We are running into the same issue on our end. We have external users in the web application and we want to migrate them off of that into an embedded ISV solution, but we can't afford to lose the export to pdf option that the web service offers. Any ideas or thoughts about this issue would be greatly appreciated. 

stuartb Frequent Visitor
Frequent Visitor

Re: Print and/or export to PDF from PowerBI Embedded Report

Firstly I just want to say that Microsoft seem to missing a trick - the paperless office is a myth and virtually all our customers want the ability to print (some A3/A2 size) Management reports. I managed to use the above project using NodeJS to facilitate printing by automating Chromium in a way similar to the link I posted earlier. As Microsoft are creating a browser based on this technology (see: Dev Edge) I don't think this deviates from most peoples concerns of browser compatibility issues - for example; CSS styling across browsers. So I'm guessing you could automate that if you needed to. 

In essence what I did, was write this as a Serverless Function (AWS LAmbda in my case) using with entry point taking HTML (or DOM document) with the Power BI Token and config already embedded. It was just a case then using Puppeteer to create a page, inject the given document and export it as PDF (to a persistent file - though returning a file stream is equally valid).  We did notice some issues with CSS - some fonts were too small and we had to manipulate some styles to get the printing 'just right'. 

In testing we found this to be scaleable and performant. Scaleability was achieved by being serverless; horizontal scaling and not having to care about the number of Chromium instances being created. Performance was suprisingly quick - most functions took less than 5 seconds, that's including loading and running chromium and the overhead of API calls to api.powerbi.com to render the reports in web page.

The obvious thing here is that it requires development knowledge in order to create this. This is not something that can be done by a standard 'business team' - Microsoft should be able to offer this functionality relatively easily, but I guess it a case of priorities?

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 472 members 5,256 guests
Please welcome our newest community members: