How To Automatically Send Emails By Linking Power BI And Power Automate

  Рет қаралды 60,727

Enterprise DNA

Enterprise DNA

Күн бұрын

Have you ever wanted to link your Power BI reports to Power Automate? Have you ever wanted to execute a Power Automate workflow recursively to a list of user-selected records from a Power BI report? In this video, Tim and Henry show you how to connect Power BI and Power Automate. They first go through the simple example of sending emails to specific records, and then go through some bonus features (thresholds, etc.) that you can add to your Power BI reports to ensure your users don’t accidentally send thousands of emails.
**** Video Details ****
00:00 Introduction
02:25 Data set
04:08 Potential issues
05:41 Fields
07:42 Creating a flow
09:02 Dynamic content
11:25 Initialize variable
13:12 Increment variable
14:51 Condition
18:46 Slicer
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-...
Enterprise DNA Membership - enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - enterprisedna.co/enterprise-d...
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerAutomate #PowerAutomateTutorial

Пікірлер: 37
@SKhan-zp7lc
@SKhan-zp7lc 2 жыл бұрын
This video literally is the best!! Greetings from the netherlands
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
Hi S.Khan, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!
@giulianatobalina
@giulianatobalina 2 жыл бұрын
Thanks!!😊
@JaisonMenezes
@JaisonMenezes Жыл бұрын
Amazing!!
@fayananrabbi3556
@fayananrabbi3556 2 жыл бұрын
Hi I have a similar process but every time my users try to use the Send Email button that triggers an email to their staff, the flow shows unsuccessful but when I do it, it works. Are there specific permissions required for users to use this functionality?
@neurosciences917
@neurosciences917 2 жыл бұрын
Thank you very much! I was inspired by your video and tried to send emails from powerbi using powerautomate I have followed up the same steps, but when I try to run the flow I get an error message. Invalid table : Null (foreach step) . Any advice plz ?
@joseraulesquivelugarte7120
@joseraulesquivelugarte7120 Жыл бұрын
Great video! Thanks for the content, a huge fan of Enterprise DNA! I have a query, if i have several mails in the table for different categories, can i add send only one email with all the data or table?
@fabianrogers3322
@fabianrogers3322 10 ай бұрын
Do I need to do anything to the data set as my power automate isn't coming up with whatever my version of "Power BI data Actual Email" ?
@manouchehr777
@manouchehr777 4 ай бұрын
Thank you for your interesting tutorial. Is it possible to put the username of the user in Windows in a variable?
@aishwaryaj6743
@aishwaryaj6743 Жыл бұрын
Hi , as I followed your steps .when I tried to run the flow I'm getting this error: "The input body for trigger 'manual' of type 'Request' did not match its schema definition. Error details: 'Required properties are missing from object: entity.'."
@binumnair9241
@binumnair9241 Жыл бұрын
HI @Enterprise DNA, Great Video, thanks for sharing. Also I have a question. What's the minimum requirement in terms of license to perform this, do we need premium in both Power BI and Power Automate to do this?
@dineshkatta9241
@dineshkatta9241 2 жыл бұрын
Can we send the email with report as a pdf attachment with the dynamic selection of date range.i.e, when customer selects a particular date range and runs the flow weather he get the data of selected date range or he get default report which is available in the service.
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
Hello Dinesh, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well, we haven't tried or created that flow so far but it might be possible to create that flow. We'll try and create a content based on it in the near future. Hoping you find this useful. Subscribe to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@alialsharqi9920
@alialsharqi9920 Жыл бұрын
How can you give every email a refrence number. For example (first email you send gets a subject number 001 and the second email 002 third 003 etc
@souravdutta3326
@souravdutta3326 Жыл бұрын
How can I sort column depending on a column object. While I am sending a mail with the button table is sorted with Date, but I want to sort it with Source.
@vlanra
@vlanra 2 жыл бұрын
Can this technique be used to notify consumers of a Power BI Report that their report has been updated
@gloriaz3711
@gloriaz3711 Жыл бұрын
Amazing video! Is there ways of trigger email based on PBI data change? Say, if I have a measure and threshold. Once the threshold is reached, an email sent out to user to let them check PBI report. Appreciate!
@iliyashshaikh6675
@iliyashshaikh6675 5 ай бұрын
same question, if anyone have answer
@kartikwat
@kartikwat 2 жыл бұрын
This is great. Can we also Automate weekly data extraction from power bi table and append it directly to an excel file maintained in SharePoint List..?
@EnterpriseDNA
@EnterpriseDNA 2 жыл бұрын
Hello kartik wat, Thank you for question. We appreciate your time. Yes, you can do that transformation as well provided the run is adjusted accordingly. For more queries, you can also reach out to us through our Community Forum where our members as well as Experts Team will be able to assist you, in a better and efficient manner. I hope this helps. Please make sure that you're subscribed to our KZbin channel so you don't miss out any updates regarding Power BI. Along with it, you may also be interested to join our Power BI group on LinkedIn to receive latest updates. Links provided below for your reference. Happy Learning!!! Thanks and Warm Regards, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@sumaiyachamroo7399
@sumaiyachamroo7399 2 ай бұрын
Can the flow run without the need to click on "run flow" button in power bi?... Meaning when i publish the dashboard for each lines in my data, they get an email without the need to trigger the flow?
@walidar5931
@walidar5931 2 жыл бұрын
Thanks for your video, does this require a pro licence ?
@EnterpriseDNA
@EnterpriseDNA Жыл бұрын
Hi Walid, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. We're providing a link below on the documentation from the Microsoft for the reference. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZbin channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ docs.microsoft.com/en-us/power-platform/admin/power-automate-licensing/types
@onigvd77
@onigvd77 Жыл бұрын
I can't get this to do anything, the button does not trigger and it refuses to run without clicking the Run button also, failing due to not having the data. dose anyone have any solutions to debugging and getting this kind of process to work?
@Wzxxx
@Wzxxx Жыл бұрын
I have a huge problem with this kind of a flow. When I share such a flow it always send and email from my mailbox. I would like it to be sent from a person who initializes the flow in BI Service.
@rohithmara9712
@rohithmara9712 2 жыл бұрын
Hi, thanks for the video. I tried to replicate the same, but it's sending duplicate emails. How to fix this?
@czowiekktoryzaduzowidzia5612
@czowiekktoryzaduzowidzia5612 Жыл бұрын
Can I send, for example, tables with the data of a selected customer only in this way?
@joseraulesquivelugarte7120
@joseraulesquivelugarte7120 Жыл бұрын
Yes, you can add the filter that affect all the page and run flow, it only willl be send it to the selected filters.
@sulm54
@sulm54 2 жыл бұрын
Hi Can I set alert for expired dat ?
@EnterpriseDNA
@EnterpriseDNA Жыл бұрын
Hi Suliman, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful! You can subscribe to our KZbin channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/
@jillsomkul1900
@jillsomkul1900 2 жыл бұрын
Hi, I cannot use the dynamic "User Email", it gives me an error "input parameter ' emailMessage/To' is required to be of type 'Sting/email'. The runtime value '"anNvbWt1bEBhY2N1cmF0ZS10aS5jb20="' to be converted doesn't have the expected format 'string/email'. Can you please give me suggestions on how to fix this problem? People keep telling me to make sure it is in the correct type, but this is not what I can change. it should automatically pull from the user email from whoever clicks the Power BI button. thank you for your help in advance
@basictalent1
@basictalent1 Жыл бұрын
Facing the same. any solution you have found yet?
@jillsomkul1900
@jillsomkul1900 Жыл бұрын
@@basictalent1 I figure out that it's a permission issue. I don't have a right to send the email on other's behalf (as you are the owner of the flow). So, my workaround is sending emails from the group email, my email, or if you are not the main contact then add that person's credential to the flow (go to the step and edit from there) and send it from that person's email. So whoever triggers the flow, the email will send out from the email I set with the disclaimer at the end of the email.
@torkilj
@torkilj Жыл бұрын
Instead of incrementing RecordCount at 13:40, can't you just use an expression like length(Power BI data), so you don't have to loop through all of them? No need to neither initialize a new variable nor loop over and increment.
@jordannyc2769
@jordannyc2769 Жыл бұрын
Well, this is not automatically sending emails, since you have a button as a trigger. Automatic emails would be triggered off of a value and conditions. good try though
@sumaiyachamroo7399
@sumaiyachamroo7399 2 ай бұрын
Any you tube video recommendation without the need to trigger the flow?
Embed a Table from Power BI in an Email with Power Automate
19:20
Christine Payton
Рет қаралды 32 М.
How To Integrate A Power App Into Your Power BI Report
22:37
Enterprise DNA
Рет қаралды 82 М.
Jumping off balcony pulls her tooth! 🫣🦷
01:00
Justin Flom
Рет қаралды 18 МЛН
10 Steps to Optimize Your Data Model in Power BI
13:41
How to Power BI
Рет қаралды 37 М.
Power Automate: Reminder Emails By Date [Power Platform Series - Ep. 16]
19:38
Power Automate - Set reminder emails from a SharePoint list
13:08
Technology and Platform Adoption
Рет қаралды 14 М.
Set Up Automatic KPI Trackers | Dynamic Alerts in Power BI Desktop
17:40
Using Power Automate to Refresh Data In Power BI
6:47
Enterprise DNA
Рет қаралды 132 М.