How to send a TABLE via EMAIL using Power Automate // Beginners Guide to Power BI in 2021

Get Demo Files here

In this video were going to go through how you can use Power Automate to easily send Power BI tables via Email

-

🚩 Support us to get perks such as demo files, early access and more!

MY FAVOURITE POWER BI BOOKS

MY GEAR

GET IN TOUCH

🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of YouTube.

If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.

🐎 First, watch this video about how a typical Power BI workflow looks like

🗺 Learn DAX to extend your Power BI calculations

📆 Stay up-to-date on all the features Power BI releases monthly

🧪 Get certified as a Microsoft Data Analyst Associate

💡 Learn Power BI Features to improve your dashboards
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.

🔻 Get started with Power BI Desktop for FREE

#PowerBI #DataAnalytics #BusinessIntelligence

[sudhansumishra]

Ohhh boy...this is Amazing man. So nice of you to do these videos and helping all of us. Keep up the good work.loads of love

[avinashmali]

Hi,
I am getting an error while running flow at SELECT level
"The 'from' property value in the 'select' action inputs is of type 'Null'. The value must be an array.
Please give some solution

[markusoestreich]

You really make very great and educational videos!

[purbashabhanja]

Big Big Big Thanks to you 😍that is what I was looking for you saved me, even chat gpt failed to provide the solution....
Thanks for your support 👍

[matiastaurizano]

Many Thanks Buddy! Regards from Argentina!

[VikasSingh-biot]

Hi,
Thanks for sharing this most valuable information on the easy way.

[vrajeshbhavsar]

This was exactly what I was looking for and really useful, so thank you for this. However, I am receiving an email per line in the table created with, all with the same output. Do you know how I can deal with this issue of bombarding emails?

[Bartman]

Hi this is great. Does this still work if you have filters applied to the table?

[kartikwat]

Very useful video. Curious to know if we can upload and append data from PowerBI table to an existing SharePoint list using power Automate...?

If yes, that would be very useful to know how it's done.

[michellemi]

Amazing instructions! Thank you for sharing

[poojamathapati]

Great Video! Is it possible to achieve the same task using automated Flow ?

[mariamelendez]

Hi! I was wondering how you can display the total value(row) that is underneath the table in an email. It shows everything like you mentioned, but I would like to add this feature

[lukedonovan]

Hey! Great job with the video. I ran into the same problem that you did as it pertains to the email summarizing the data. But when I go back into power automate, I do not have the ability to uncheck the "sum" option, does it matter that the columns are all quick measures in my table? Also, after creating the "Select" step, is there another way to export other than creating the HTML table?

[divya]

Thanks for this 👍💯.. I have one more requirement along with this, I would need Grant total "total "also in the content of the mail body... Can you please help me...

[saifali]

Really helpful. Can you do a video on exporting paginated reports as pdf/ppt and saving the file on a SharePoint folder using power automate.

[tejaschandan]

Hi, thanks for the video.
I just had a small issue. I am not able to export the table because it says there are too many rows.

[nivi]

It's very useful to me.. please upload that how to send report via email using power automate in power bi desktop

[raudathulfathirah]

Hi,

Can you assist how to send this tabular report to multiple unique users? appreciate your help.

[Cappurnikus]

Any idea how to get the row count of the power bi dataset so that you can conditionally send the email?

[devyanianimalsjadhav]

Can you please show us how to read an excel and creating a table of those value and including that table in emails