Power BI - Export Report and Email to Current User (Power Automate)

In this Power BI tutorial, we learn how to send an export of a Power BI report to the logged in user, or any list of users! This method uses both Power Automate (Microsoft Flow) and buttons within Power BI. This is a fun trick that demonstrates the power of using multiple technologies within the Power Platform!
To enroll in my introductory or advanced Power BI courses:
training.bielite.com/
Elite Power BI Consulting:
bielite.com/
Data Insights Tools:
www.impktful.com/
Download the PBIX:
www.dropbox.com/s/87vkdheqo89...
Ashley's BI Blog:
www.bi-bootcamp.com/
Connect with me on Twitter!
/ powerbielite

[@willyms]

I never get tired of saying how resourceful your videos are! Thanks again!

[@HarishS12137]

Great work, I was just struggling on how to trigger an email to multiple users and this would really help me!!

[@solomonrobert67]

Excellent Video. Just completed implemented it. Followed your steps and am done! Thank you so much for the knowledge.

[@pucca9090]

Exactly what I am looking for. Thanks

[@mohhassan2551]

Thanks a lot to present this feature , very helpful . Is there a way to send a filtered report ? i am trying to apply some filters then export & send but the method in the video exporting only the saved report without applying any filters .

[@anastasianikolovski8337]

Many thanks for this video! May I ask you if the RLS is already implemented with Power Automate? We need to set it up for our paginated report. So far we couldn't make it. Thank you for your feedback in advance!

[@lindaringnalda1853]

This is great ! Unfortunately, I cannot use the HTTP request and email function because of security restrictions. Any way I can create an= simple export button in PBI without those options available?

[@PrabhatKumar-tn3be]

Hi, it is really useful and helpful. I have two questions 1) can I split the email addresses between TO and CC? Currently all selected email addresses are in TO field only. 2) I want to add one more customized text box where the user can add/type the email content before sending the report. Many thanks

[@solidoffortitude]

Very nice! If only Power BI also allowed us to export formatted reports into editable formats, like Excel and Word.

[@BIElite]

What a wonderful world that would be :)

[@PrabhatKumar-tn3be]

Hi, It is really helpful for the team; especially when the report is shared between multiple departments. Great Job!!! Many thanks Is it possible to export a Table/Matrix data to Excel with Button or Trigger? Currently struggling with this... your help would be much appreciated. Thank you

[@jeffrey6124]

Is there a way to export the whole datasource in an sql server connection from the Report view into csv? ... Really appreciate the help. Thanks

[@jerrydonbuckholt]

Can I export the file in .xlsx Excel format and email it? Can't seem to locate a way to do that.

[@balajia3592]

Thanks for the content. Is there a way to export Summarized data to Excel via Power Automate?

[@ryanmontgomery5863]

Parker - if you export the report as an image, is there any way to embed in the body of the email? I've been trying variations of this for hours with no success.

[@letiziabellavia2488]

Hi, thanks for this video. I have a question: how can I show a preview of a report directly, without click on the attachement?

[@lizimorley7703]

Can this be done with Power BI Pro or with Premium only? Thanks for the video! :)

[@MikeSunTzu]

I got it all the way until the last bit, how did you add the flow url to the fields?

[@anthonjhnon1]

Can you select filters in the PBI report with Power Automate?

[@sheron_kitchilan]

Can we do the same with Pro Licenses or is it a must have a Premium capacity

[@kittydoes7600]

this is nice. though it's not working froom my end. the flow run successfully, but didnt get the email.

[@hereforggyu]

Is bookmark name feature already working? Thanks

[@jugarGV]

Hi BI Elite, pleased to be part of this great Community. Let me say than I´ve been having some troubles running this flow, I get an error that says "FeatureNotAvailableError" on 404 code. I was wondering ¿you or someone have experienced this issue? ¿ Is it possible to fix it? Anyway, thank you so much for all of your content. Greetings.

[@excelrati]

Thank you for this great video 👍🏻 Is I have a slicer with 2-3 values on the report page. Is it possible to request the power automate to cycle through all values in the slicer and print the result after each selection?

[@MrRohanroxx1]

Did you find a solution for this ? I am facing the same issue rn

[@excelrati]

@@MrRohanroxx1 Unfortunately not...

[@chakrisai7406]

If I select a filter and then click on that mail image, then instead of sending the filtered power bi report, it is sending whole report. How can I send only filtered report in pdf.

[@karthikvalluri8125]

The exportToFile api still needs pbi reports to reside in premium or embedded capacity..so premium per user might not work.. I tried and got a “featurenotavailableerror” also the same api works fine against a paginated report residing on premium per user - thanks

[@kavitasable9462]

Hi, Can you please tell me, in button in Action and tooltip,in Web URL, which link you paste?, Flow URL measure ? or HTTP URL GRT link? please specify. So my report will work.

[@pooneh1894]

Hi, is there a way just to export the actual page?

[@Flowerloveesun]

Hi Parker, thanks a lot for the great demonstration! Just one question, triggering the html flow always opens a new tab in the browser. How can we avoid it?

[@anadumitru2829]

Hello Sheik, did u find the solution?

[@Flowerloveesun]

Hi Ana, I have not found any solution with this process. But, I applied different flow with power app integration to do the same task.

[@vinayakp4943]

Hi @@Flowerloveesun , which flow did you add ? can you please show it ?

[@danaalissawi8345]

Would I be able to export a table in a published power bi app but I have no access to the workspace nor the data source? (I.e. just the actual dashboard through the shared link) Currently, the data gets updated every month and I need to go every month, filter last month’s data and export it using the 3 dots>export button. I would like to automate that process. Any idea how?

[@aleksandarbbb1051]

I downloaded example file but powe bi desktop can’t open file ( like it is corrupted). What I don’t understand is how to assign flow measure to button. I used action type = web url and as Web url I picked ups measure. When U click button browser oppens. I want to avoid oppening broeser. Is it possible ? Thanks

[@patlittleton1288]

Is it possible to have reports automatically send via email as an Excel file?

[@williamleveson-gower5088]

Hi Parker, great video, thank you !!. Do you have an update on Power Automate with Power BI Premium Per User?.

[@chonghongyi5935]

Im still wondering whether it works or not. Have you try it William?

[@Bharath_PBI]

Hi, great and very useful video. All these years have been working with power bi and now it's time to look around it, the power platform. Any suggestions to start with?

[@ryanhall1256]

When I open the attachment (pdf or pptx) in the email the file does not contain any data, your feedback is appreciated.

[@gagankang9472]

Hi, can you use Power Automate to export in Excel? Also, I am having trouble in exporting into multiple tabs

[@shoeb1359]

Hi Gagan, are you able to resolve? even i am struggling to get the data export in excel for table visual.

[@andreaalejandragutierrezam1751]

Perfect! :) I already tested. Is it possible to change the source mail, I mean, the sender?... so I can use a corporative email instead of using mine. Thanks a lot!!!

[@BIElite]

Good question! I'm not sure. Depending on which email action you choose, I know you can either send via your email address or "Microsoft Power Apps and Power Automate" which I used in the video.

[@andreaalejandragutierrezam1751]

@@BIElite thank you so much! I'll investigate a little bit :) Thanks!!!

[@rolandszirmai3922]

@@andreaalejandragutierrezam1751 You have to log in to Power Automate with the corp account. It should pick up that e-mail address as a sender :)

[@manoharp5496]

Nice one ! But is there a way to avoid opening another tab that triggers the http request for the flow when we click on the button/action.

[@SuperMethodeman]

I facing the same problem. Was wondering if you found a solution.. I thought I was missing something...

[@rakshithbukkit4802]

Hi Manohar, same issue with me. If you find the solution please share. Appreciate your response in advance!!!

[@anadumitru2829]

Hi, did u find the solution? I am facing the same problem.

[@ncbshiva]

Great work, Could you also please let us know if this works with Row Security Level ? Which means only people can see their own country data after exporting to PDF.

[@shijasj]

Hi Shiva kumar - did you get a solution for this? I am also searching for it.

[@ncbshiva]

@@shijasj No, I am still searching.

[@rakshithbukkit4802]

@@ncbshiva Same requirement. Did you get the solution? exporting their own data to PDF

[@andreanikitacavaletti9761]

are you sending the actual report or the defoult report? I mean, if the user change the view with a bookmarks, he will be export the new view given by the bookmark?

[@BIElite]

Currently, this is sending the full report. Bookmark support hasn't been enabled yet for the Power Automate action.

[@tarachag2825]

i've got "Report requested for export is not on dedicated capacity" error when testing. please advise if you know the solution. Thank you.

[@BIElite]

Hey Tara, your report needs to be in a workspace that is on dedicated capacity (Power BI Premium, Premium Per User, or Embedded).

[@rakesmanna6046]

@@BIElite Hi, First of all it's a great example. I have only Pro license so I also encountered the same issue of Tara. Is there any possibilities to achieve report export( Particular page with several bookmarks) functionalities in Power BI Report Server ( Comes with the SQL server Enterprise license) ?

[@juannicolascorreaagustin5103]

Yeah i have the same proble like Rakes and Tara, there is a any posibility wit a licence Power BI Pro?

[@henryburkhardt4160]

@@BIElite I do not think "Premium Per User" is enough. It is not working for me. I am getting the same "...not on dedicated capacity" Error. It seems you need to spend 4k per month for a capacity in order to be able to export to PDF using Power Automate. Shame on you Microsoft :-(

[@tejasbrahmbatt5344]

Great video Parker.. Nice to see how the over all Power Platform works together.. I am still not sure, why would someone click a button on the report to export the report ..? They can simply use the native export functionality from the headers.. But overall, nice to see this new functionality.. :)

[@momolovemusic]

Hi thank you for the great information. 1. Currently our company host power bi server in the intranet, do i need to install microsoft on a dedicated server as well? 2. How do the flow able to access the power bi report if the report has RLS settings? So the flow will login to powerbi then export view based on the RLS definition of that user? Can flow handle this access issue? Thank you very much. Regards.

[@bns789]

Hi Nicholas, I had the same concern. As I have send a report to many people. Will the RLS logic work and each of the pdf generated is unique to the end-user?

[@ashu60071]

Sending Report is throwing an error. can you help

[@Prashantpatil-cq3yt]

Can you please provide your pbix files along with the content on your website so it ll be useful...

[@BIElite]

I'm a bit behind on creating blog posts at the moment. I've uploaded the PBIX to Dropbox though. See description

[@surafeltilahun7404]

does this work for power bi pro or just for premium?

[@BIElite]

Premium, embedded A4, and premium per user!

[@NaraMeerammaTrust]

Great if you can upload .PBIX file. That will be a great helpful for your subscribers.

[@BIElite]

Uploaded the PBIX to a temp location. See the description :)

[@taylorhan3681]

I also got an error when triggered flow "Report requested for export is not on dedicated capacity"? Anybody know why this happen? thanks

[@BIElite]

Hey Taylor, in order to use this method, your report needs to be in a workspace that's on dedicated capacity (Power BI Premium, Premium Per User, or Embedded).

[@taylorhan3681]

@@BIElite Thanks for the clarify.

[@TanjilulA]

@@taylorhan3681 Hi, can you confirm whether or not you have managed to fix your issue? If so, then how did you do it?

[@dickvanklaarbergen5811]

I get this error: {"error":{"code":"FeatureNotAvailableError","pbi.error":{"code":"FeatureNotAvailableError","parameters":{},"details":[]}}} when I do this. Does anyone know how to solve this?

[@mohammedraffi964]

I also got the same Error. @BI Elite can you please assist us on this.

[@saajids1123]

bit late on the rreply as i just saw this now, from my experience, this plug-in only works if you have dedicated capacity workspace in which the reports are being run/generated on. It does not work on Pro or Premium Per User License. Really sucks that microsoft display plug-ins on license options they are not provisioned to work on.

[@germanhenriquez24]

Do you need Power BI Premium??

[@juannicolascorreaagustin5103]

Yes :(

[@TanjilulA]

@@juannicolascorreaagustin5103 Will Premium per user work?

[@stlaurent26]

It is total BS that MS limits this function to Full Premium capacity only, it locks out vast majority of (PRO) users

[@roya75]

tsk up speak is annoying