How to Send Power BI table data as CSV file to Email? Use Power Automate!

How to Send Power BI table data as CSV file to Email? Use Power Automate!
This video shows you how you can allow your end users extract the data behind your visualisations for further analysis. It's possible using Power Automate. It's incredible!
Watch and enjoy!
Learn everything you need step by step!
Act like a pro!
In this channel you will learn Power BI Tutorial for Beginners to Advanced.You will find different training on Power BI desktop, Power BI service, DAX, Power Query, analytics, and dynamic reports
You can find more business intelligence tutorials blow:
Please read articles on: www.hogolytics.com
Follow me on LinkedIn: / sh-hogo
Follow me on Instagram: / dr.shahab.hoghooghi
#dataanalytics #powerbi #dimdate #powerquery #refreshtime #refreshdataset #powerautomate #refreshreport #incrementalrefresh #slicers #Slicer #filter #slicerpane #theme #color #colors #extension #googlechrome #mozillafirefox #microsoftedge

[@jill5652]

Thank you!

[@enocharthur4322]

Best tutorial I've seen so far on this subject

[@hogolytics]

Thanks for your warm words

[@andrezocco]

best tutorial! thanks for saving my life haha!

[@RDBclub40]

Thanks

[@thenowbasket]

This is great! thank you

[@hogolytics]

Happy you liked it

[@llewellynemmanuel9907]

Thank you from one power bi lover to another.

[@hogolytics]

Thanks for your comment and hope you always enjoy working with Power BI

[@llewellynemmanuel9907]

Can you assist on something? I published this to service and the button only works for me. When other users trigger the button, it says "unsuccessful"?@@hogolytics

[@DB-Au]

This is really handy!

[@hogolytics]

Thanks. Happy you liked it.

[@michaelshannon7475]

This is absolutely perfect for my work needs!!! One issue is that it is sending an email for every record I have in the attached file. Email is a duplicate with the correct attachment. For example it is a shipper information and a record for each shipment. Any solution for duplicate emails?

[@MrTC-rv3jo]

Great video! Any idea how do I make this with a schedule cloud flow and not a click button? Im not able to get the CSV in the format of a table (only as a one-line output inside the CSV file) .In my case, it is sending an email but I want to send the output table as a CSV file... thanks!

[@MiteshYadav]

Awesome, one question Can we update the whole table in same file, based on selection?..

[@emiliomira827]

Than you very much for your tutorial.One question please: How could you assign a subject to the email that depends on a data value in Power BI? I am referring, for example, to a value by which we have previously filtered in Power BI

[@sgtkarhu6844]

Hi! Great lesson. How would I got about creating a dynamic filter for the content based on a different table of contacts coming from SharePoint?

[@H4NAKOO]

The flow is working and I am getting the output as expected, the only issue is I am getting multiple emails after triggering the flow.

[@HarpreetGujral27]

Thanks for this amazing tutorial. I need one help, how we can send multiple csv files or tables in single emails

[@manouchehr777]

Thank you for your interesting tutorial. Is it possible to put the username of the user in Windows in a variable?

[@ramyarangasamy3770]

Is there a limit to how many columns you can have in your Power BI table.We have 25 columns in the dataset to run .Can you please suggest possible ways to get all 25 columns in the mail.

[@muhammadajmi4887]

how about xlsx format?

[@s.r.1997]

really nice but sadly, seems to be limited...when i try to save a csv normally from the 3 dots, no problems, but when I try to use this flow, it says I've too many data in the column and ask me to reduce them...but I can't, I need them all... any solution @Hogolytics? 2nd issue: even if I selecet 1 row and the exclamation mark disappear, it doesnt run, and dont send any email...

[@rangsubbesrikanth3306]

Thank you for sharing valuable information... Here my question is incase we have multiple pages in a power BI report then I need to export all the pages table information at a time in CSV so..could please confirm me Is this possible?

[@hogolytics]

Thanks for your comment. You can insert any attribute into Power Automate data field and use it. It doesn’t matter if they’re in different pages. But when you are creating CSV table, you need to create 3 different CSV tables.

[@nishitanathani1052]

Hi, This is a very interesting video, great explanation. However, I am able to trigger the flow without any issues. But other users are not able to trigger the flow and it just says Unsuccessful on the button after showing triggering. I don't see their flows being triggered when they click on the button on the run history page. Please guide on how to make it possible. Thank you in advance.

[@hogolytics]

Hi, Thanks for your comment. You should define who can trigger the buttons. There is another video on the channel about Power Automate settings. If you watch it you will clearly understand how to deal with it.

[@newbobotime]

Really well done videotutorial, congratulations! Only one info: Why do I only see the user id and not the user email when I have to insert the email recipient as dynamic content?

[@hogolytics]

Hi, thanks for watching the video. Please change the data type to text and your issue will be solved. Cheers

[@newbobotime]

Sorry, I don't understand, where should I change the data type to text?

[@hogolytics]

@@newbobotime First click on each column you like from Data panel on right hand side, then from Column tools tab on top, change the Data type from date or numbers to Text.

[@newbobotime]

🙄

[@newbobotime]

Once I select the table fields to include in the table that I will attach to the email, how do I convert them to text? What do you mean by: "Column tools tab on top" ?

[@manoharkandikonda4298]

Hi, thanks for detailed video. i am encountering a problem here. i am getting emails for each record, received 26 emails as i have 26 rows in table. is there a way we can avoid this?

[@hogolytics]

Hi , thanks for your comment. It’s because you’re sending each line of data to the related emails in the recipient column. If you want to just send the data for one time to people’s emails, there is another video on the channel about sending data to users emails in a csv format. Maybe that one is what you need to watch and apply.

[@jmc-23]

Why is date format types not appearing on dynamic content?

[@rajeshpatil8885]

Hello Thank you so much for this video. mail is not triggered

[@hogolytics]

Hi, have you tried yourself or other users cannot trigger?

[@rajeshpatil8885]

@@hogolytics some issue with at the time entering mail id but it is cleare now But i need other help i want sent table in mail body as a attachment from power Bi by power automate

[@pthapa55]

When I click on the button, why am I getting four emails at the same time even though I clicked once on the button? Can you please suggest. thanks

[@dezhenghuang6945]

Amazing! thank you for the great info! Can it be automated? like auto trigger in a schedule?

[@hogolytics]

You can use automated flows, for example send email 2 days before the due dates

[@jordanlivefitoutdoors]

This is great! Is there a way to trigger the email without clicking on the button yourself? For example, scheduling the flow to run daily at a certain time. Thanks!

[@jordanlivefitoutdoors]

@hogolytics I'm also getting an error on the Create CSV Table step with the error: "BadRequest. The property 'columns' must be specified unless the 'from' property value is an array of objects.". Any ideas on how to fix this? The column is currently set to automatic.

[@hogolytics]

@@jordanlivefitoutdoors yes, here I used instant cloud flow, you can use a scheduled flow or automated flow. Those ones can be created from powerautomate.com

[@hogolytics]

@@jordanlivefitoutdoors Please check if your columns are in text format

[@jannatulf6415]

Hi, When I click Run flow, nothing happen. Can you please help

[@rakeshkarekar8552]

But only give you 1000 rows .. how can i get it actual size when i select something in slicers

[@hogolytics]

Unfortunately it’s the limitation for now. It’s good to write an idea on Microsoft community or search and vote an existing one. Then they might increase the limit.

[@user-md4ir2ir2f]

Hi, I am getting the below error. Could you please help me out? The execution of template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerBody()?['entity']?['Power BI values']' is of type 'Null'. The result must be a valid array.

[@idno8955]

(I know I'm late) Whatever you're expecting to loop through it empty, it can't loop through null

[@sandeepsahoo921]

Hi..thank you for the helpful video. I need help. I am getting error while try to send report in email - " the execution template action 'Apply_to_each' failed: the result of the evaluation of 'foreach' expression '@triggerbody()?['entity']?['Power BI values'] is of type 'null'. The result must be a valid array. Would you please help me here?

[@siddhantpati1358]

same error

[@enzo6940]

Thanks for the info! Does anyone know how to send as excel instead of CSV?

[@hogolytics]

Excel is a little bit more complicated. You need to save a file on SharePoint and apply some tricks. I try to create a new video for it soon.

[@syazwanisaid7104]

hi HOGOLYTICS, i follow all the steps but when i click on the button, the automate is not triggered. Can you advise. Thanks!

[@hogolytics]

It’s not working for you or other user?

[@abhishekhkumarrai5114]

This method is not working...getting an error in apply to each section...is it possible to connect with you on teams or zoom?? I am applying the exactly same method

[@vidya7453]

how to send power bi table as xlsx format file to email sir?

[@hogolytics]

If you're looking for an Excel file, you can save it on SharePoint and every time overwrite it.

[@andresgf7547]

Hello, Thank you very much for the video. I get more than 300 emails ... could you help me ?

[@hogolytics]

You need to create Azure AD groups

[@methagen]

I get the error message "BadRequest. The property 'columns' must be specified unless the 'from' property value is an array of objects." have tried to fix it by googeling but with no luck

[@hogolytics]

Please be careful to use { } curly brackets not square brackets [ ]. Please check if you made this mistake and hope your issue will be solved. Cheers.

[@methagen]

@@hogolytics Thank you so much for your reply. That worked to get me a CSV file sent - but it does not sort the columns as your example. Everything gets into column A, even though i chose Array type as you showed

[@ertgrlars1]

@@methagen Hello. I have the same issue. Were you able to solve the problem?

[@methagen]

@@ertgrlars1 I used a video from Christine Payton instead

[@perfectionist6624]

I am getting only 1st record 1000 times in an email. Please help

[@DB-Au]

need to give users permission to use the flow

[@hogolytics]

There is another tutorial on the channel on how to change the settings for Power Automate. Just watch that one. Described everything there.