Totally. Like i want to be able to select some properties on a map, then press a button to generate their inspection reports from SSRs into the inspectors' email.
It solves two problems of my customer instantly. I was to create a new report but now I think using this I need not to do that. Thanks Patrick great stuff
Hi Patrick, have you heard or discovered any method to automate the Power Automate Visual button? So it would be possible to use the dynamic content from Power BI in scheduled flows? Love your content!
I agree with this! Need to export a dataset every day while managing multiple accounts, but not all end users of the report can receive the export so currently having to manually click the button every day
You can create an automated flow directly in Power Automate with this same data set. You will get the option to schedule and Automate with all available triggers.
Is there a way to create an automated workflow instead of a manually-triggered one with the Power Automate integration? What would I need to do if I wanted to run it every morning?
Hi Patrick, great video, thank you! I'm trying to use it for corp credit cards. Can we send the emails to only those employees who have not coded their expenses over 45 days since the expense date?
Hi Patrick, thank you for sharing. I created a power automate flow to send filtered data from a PowerBI report as a excel file via email, however this is user triggered via a click. Is there a way to schedule both exporting powerBI report data into an excel file and sending via email? your help is mostly appreciated.
Thank you Patrick for making this video. I'm trying to do similar things for my use case. I noticed tht it can only refer to Power Automate flows created in the default Power Automate environment. Is there any way we can refer to flows created under custom environment in PowerApps? Appreciate your guidance.
Thanks for the instructions. Can we somehow automate the process without using a trigger button and instead trigger it whenever the BI report is refreshed? Seems not quite 'automated' to me if we need to click a button every time to get the data sent.
Thanks Patrick! I have a question - if a customer had more than one order in the table is there a way we could consolidate that into one email, instead of potentially obliterating their inbox?
Hi - is there a way to export ppt using power automate after we published? and also we can create different powerpoint slide based on changed filter (name) so we dont have to manually do it?
Hey! Thank you for the video. It's very helpful. I have just one concern: In case I want to export a PowerBI file to a .pdf and send that as a mail attachment. Can I do it with Power Automate?
Great video. I tried this and added a switch condition to the power automate flow. Basically if client name was X send email 1 if client name is Y send email 2. It got stuck in a loop! 600 emails later I cancelled the flow. Seems to work as long as there is only one linear flow without conditions. Is there a way round this, so you can add switch or other conditions?
Thank you for your video. But, when I did these steps by you, I still couldn't run the flow successfully. The status is "Failed". where can I check errors in PBI? Thank you
Hi Patrick, at the moment, the sender of the email is the flow owner. is there a way that the flow picks up the email address of the person triggering the flow (i.e. clicking the button)?
Hi Patrick, thanks a lot for this video. I just wonder if it is possible to group such emails. If some recipient has more than one items I would like to send out just one email containing the list of his items, instead of sending individual emails for each item. Is that possible?
Hi Patrick Thanks for all the video. I have a question whether it is possible to send a table or visual of data from the power bi service or on the desktop to a regular email in a timed manner but with relevant filters for that period and person. Say once a week last week's data according to the selected team manager who is the recipient in the email
I have some specific format or you can say template which includes images and formatting also needs to attach the emails that were already sent is it possible to add all using the Power BI and Power Automate?? If yes, then i would like to know how? Thanks
This is great... but to take it to the next level, is it possible to change the Power Automate trigger from a Button to an alert? Or to schedule the flow to run every 24 hours?
This is amazing. So many applications. Is there any way for the run permissions for the flow to be inherited from the list of authorized users of the report?
Hi Patrick, Thanks for posting the video, can the flow visual apply the RLS applied on the report and send the table visual contents of a report as excel attachment with RLS applied on the exported report.
RLS will be applied, but you cannot send a table. If you wanted to do something like that you could use a subscription or take a look at this video ruclips.net/video/NkiUC-jR67s/видео.html.
Thanks, your videos have helped me a lot. I have a question...If you add a parameter that has a decimal from Power BI, how do you truncate the output of that parameter? When you execute the email trigger, the output is showing up in the email in a format of "0.00000000000000".
I have a question about the power automate "Power button clicked"; It is currently delivering a NULL data from the columns I added to it. The output is restricted to {}. Do I need to publish the table (Power BI) to get the power button function work properly? Or do I need a power automate license? Any feedback would greatly appreciated
Awesome video! Would love to see a video on how to use power automate to select an item in a power bi report, and ask the user to come back into that same power bi report and fill in some comments in a power app visual. For example, why is this item not done yet?
I am building a similar scenario like this at the moment. I am using a Power App within the Power BI Report which enables the users to add data to the dataset via Excel. The Power BI Dataset Refresh action is used to sync the Excel workbook and the dataset. The source of the dataset is the workbook. I will post a video of the solution on my channel once it is done : ruclips.net/channel/UCLGfygRlwhsekVv7UiRhwXw Please subscribe to get notified about it.
Hi Guy in a Cube, I really enjoyed this video. I have a question though. How can I send an automated power bi report that shows the daily transactions(real-time)
Hey Guy in Cube, i want have an email button to open a new empty email from power bi to be sent to deferent email users depends on selection, can i do this ?
This is awesome!!! It will help me save a lot of time!! I had just a question, hoping you answer me or make a video about it 😆 when I tried running my flow, I got the error "manual failed". I set conditions before the action of sending the email, so not sure if that's the issue ☹
Is there a way to get the power bi dataset row count without looping through the whole dataset? For your example, how do you stop the user from sending hundreds of emails?
I love this new visual, currently setting up a report that people can use it for to pre-populate some people review forms. I just wish the permissions for running the flow could be a bit smarter. I'd ideally love to be able to either give access to run it to everyone in my organisation and/or everyone who has access to the report. Just a slight pain that I'll have to manage another security list for something that is only ever going to be embedded in a report that I already control access to anyway. As you say, I'm not lazy, just efficient lol
Hello, I'm just wondering what happens if the customer replies to the email they received from Power automate? Who receives the email? Would it go to the Power Automate department in Microsoft?
Q: First of all thanks for sharing your skills. I am wondering how to make the Power Automate flow send an email from the account of the person who triggers it. As ehen I tried, the person who is triggering is using my mail to send. Could you please help?
Hey Padrik, Can we directly send an already setup visualization page not the fields to mails by using Power Automate!!!!! , I was struggling in presentations in everyday for each team performance by selecting the each team in a slicer.
Thats awesome we can create automate flow inside the context of Power BI. But when I try to trigger that flow from sharepoint published report it will not be triggered where it will work fine from Power BI desktop. Do you have any idea ?
Great video, Patrick. Can you explain/make a video on how you would implement Power Automate flow within an embedded Power BI Report? How can you enable external users of the embedded report to trigger the flow? When you don't know their email address?
Do you have to enable power automate or something? When I click edit I get the blue bar at the top that says Microsoft power automate but then nothing else happens
Thank you Patrick for sharing the knowledge. I have used this real world scenario at my work. Inorder to take it to next level, currently we are able to show numbers (from Measures) in Mail. My query is that, can we include Visuals in the customized mail which is triggered.
Hi, Patrick... I was attempting to follow your video, and sending emails should be straightforward. However, I'm encountering an issue with the "Power BI Button clicked" step. It seems to have a null output, even though I selected one column from my dataset. Have you encountered this before? I'm wondering if you have any insights on why this might be happening.
Hey Guys... Ever considered to make a series of "Guy in a Flow" featuring Power Automate stuff? I would be your first and most appreciating customer!
Not really! Most of our focus is Power BI, but definitely something to consider.
@@GuyInACube Already 38 thumbs up. Do you see the massive demand? ;-)
@@GuyInACubeThis would be VERY helpful for me as well!!
Totally. Like i want to be able to select some properties on a map, then press a button to generate their inspection reports from SSRs into the inspectors' email.
@@GuyInACube Please!
Every time I watch one of your PowerBI videos Patrick my brain explodes with new capabilities. This is just in time for a report I’m working on.
Can you schedule the flow to run at specific intervals? Like every morning at 10am for instance...
Looking for something similar.
It solves two problems of my customer instantly. I was to create a new report but now I think using this I need not to do that. Thanks Patrick great stuff
Hey Patrick. Is it possible to use Power Automate to send an email when a threshold is reached/exceeded?
Neat stuff! This opens up new options for me. I've used Power Automate to send exported PPT versions of BI reports.
Nice. I am trying to do this currently, how did you figure it out?
Hi Patrick, have you heard or discovered any method to automate the Power Automate Visual button? So it would be possible to use the dynamic content from Power BI in scheduled flows?
Love your content!
I agree with this! Need to export a dataset every day while managing multiple accounts, but not all end users of the report can receive the export so currently having to manually click the button every day
You can create an automated flow directly in Power Automate with this same data set. You will get the option to schedule and Automate with all available triggers.
Great video! How can we force data to be filtered before triggering the flow, so that someone doesn't click button and send to all users in report?
So many possible uses for triggering actions via PowerAutomate beyond just sending emails. Thank you for sharing, this opens up tons of possibilities!
Yes, the possibilities are endless. Thanks for watching
Is there a way to create an automated workflow instead of a manually-triggered one with the Power Automate integration? What would I need to do if I wanted to run it every morning?
Hi Patrick, great video, thank you! I'm trying to use it for corp credit cards. Can we send the emails to only those employees who have not coded their expenses over 45 days since the expense date?
Hi Patrick, thank you for sharing. I created a power automate flow to send filtered data from a PowerBI report as a excel file via email, however this is user triggered via a click. Is there a way to schedule both exporting powerBI report data into an excel file and sending via email? your help is mostly appreciated.
Hi William, did you ever find a solution to this?
Thank you. You answered my question in less than 60 seconds
hi this is awesome! do you happen to know if exporting a summarized table/data can be sent via email as an attachment? is this possible?
Thank you Patrick for making this video.
I'm trying to do similar things for my use case. I noticed tht it can only refer to Power Automate flows created in the default Power Automate environment. Is there any way we can refer to flows created under custom environment in PowerApps? Appreciate your guidance.
Thanks for the instructions. Can we somehow automate the process without using a trigger button and instead trigger it whenever the BI report is refreshed? Seems not quite 'automated' to me if we need to click a button every time to get the data sent.
@@reaperqnu I thinks use schedule option
@@dramaraju3970 I thinks use schedule option - where is the option can you please help thank you
Another masterstroke Patrick 👏
Instead of triggering it manually, can we schedule it?
Hi, thanks for this video. Just a question: how can I show a preview of my report directly in mail without click on the attachement?
Thanks Patrick! I have a question - if a customer had more than one order in the table is there a way we could consolidate that into one email, instead of potentially obliterating their inbox?
That's my case. I need to send multiple rows to one email. Each row has the same email...
Looking for the same info :)
Find a solution?
I have the exact same issue. Did anyone get a response or can anyone reference another place to make this change?
great video. do you have a sample of the report you used?
Will be amazing if you can schedule this flow without Premium user. Great video Patrick.
Yeah. That is a good point Victor.
Ha Patrick, is this also possible without a button in your report? The trigger fron the Power Automate flow is then scheduled. I hope you can help me.
Hi - is there a way to export ppt using power automate after we published? and also we can create different powerpoint slide based on changed filter (name) so we dont have to manually do it?
Great stuff ! Can you configure your emails trigger automatically if some condition is met ?
Love this!! Clearly I have been living under a rock somewhere. Thank you!
can you help with using a Power Automate button to open a report (combined with cross report drill through). THANKS!!
Hey! Thank you for the video. It's very helpful.
I have just one concern: In case I want to export a PowerBI file to a .pdf and send that as a mail attachment. Can I do it with Power Automate?
Hello I love this. But do you know how to configure so whoever executes it, is sent with his user?
Hey Patrick !!!
Will you be able to give the dataset for practice purposes please...???
Q : thanks Patrick. Can we export a Matrix table and couple of other KPIs as is from PBI report into an Excel file and send that as attachment?
Great video. I tried this and added a switch condition to the power automate flow. Basically if client name was X send email 1 if client name is Y send email 2. It got stuck in a loop! 600 emails later I cancelled the flow. Seems to work as long as there is only one linear flow without conditions. Is there a way round this, so you can add switch or other conditions?
Thank you for your video. But, when I did these steps by you, I still couldn't run the flow successfully. The status is "Failed". where can I check errors in PBI? Thank you
Hi Patrick, at the moment, the sender of the email is the flow owner. is there a way that the flow picks up the email address of the person triggering the flow (i.e. clicking the button)?
Is it possible to trigger a Power Automate flow from a measure instead of a manual button click?
Hi there. Can you input data directly into excel and it automatically updates on Power-Bi without using MS Forms?
It is amazing!!! Is it possible to send a whole table in attachment?
I am looking for something similar. Let me know if you found a solution to it
does workspace have "manage alert" feature in the report? cause I would like to send my report but only during specific threshold, like a warning
Hey Patrick nice work, How can we send 2 out of 4 visuals in power bi reports using power automate scheduled refresh ???
Hi Patrick,
thanks a lot for this video. I just wonder if it is possible to group such emails. If some recipient has more than one items I would like to send out just one email containing the list of his items, instead of sending individual emails for each item. Is that possible?
Patrik.. Can we email visuals using the Power Automate feature?
Thanks for the video, is it possible to upload the PBI report directly into sharepoint using powerautomate ?
Regards,
Vasudev
Hey Patrick, that's preety awesome.
I liked the thought and it really make sense to have it in a business report.
Thanks for featuring it.🎉
Great vid, but how might you add the values in the table of data? It doesn't seem to be available to select in the dynamic list.
Top video. Didnt know we could integrate Power Automate with Power BI until I watched this vid. Many thanks.
Hi Patrick Thanks for all the video. I have a question whether it is possible to send a table or visual of data from the power bi service or on the desktop to a regular email in a timed manner but with relevant filters for that period and person. Say once a week last week's data according to the selected team manager who is the recipient in the email
Not with this approach, but you can try a subscription or take a look at this video ruclips.net/video/NkiUC-jR67s/видео.html.
@@GuyInACube That's what I'm talking about. You guys are great
Can you do scheduled flows from PowerBI? I need to run a report daily for my users, and I'm trying to figure out how to do that...
Can I schedule email every week? Like do not need to click button?
I have some specific format or you can say template which includes images and formatting also needs to attach the emails that were already sent is it possible to add all using the Power BI and Power Automate?? If yes, then i would like to know how? Thanks
This is great... but to take it to the next level, is it possible to change the Power Automate trigger from a Button to an alert? Or to schedule the flow to run every 24 hours?
I second this question!
Also would like to schedule/automate the flow every week
Can you attach to the email a full table or chart from the visual?
This is amazing. So many applications. Is there any way for the run permissions for the flow to be inherited from the list of authorized users of the report?
Hi Patrick, Thanks for posting the video, can the flow visual apply the RLS applied on the report and send the table visual contents of a report as excel attachment with RLS applied on the exported report.
RLS will be applied, but you cannot send a table. If you wanted to do something like that you could use a subscription or take a look at this video ruclips.net/video/NkiUC-jR67s/видео.html.
Thanks, your videos have helped me a lot.
I have a question...If you add a parameter that has a decimal from Power BI, how do you truncate the output of that parameter? When you execute the email trigger, the output is showing up in the email in a format of "0.00000000000000".
Hope u had given the link to excel info table that u have used
Hey Patrick, you know if Power Automate visuals work when the report is share on SharePoint ?
How do I set this up as a recurring task in Power Automate with the dynamic content from Power BI instead of clicking a button?
We are in gcc. And the power automate visual just is blank . Do you know since it is in preview whether it will connect to gcc soon ?
Hey Patrice this power automate is required licence for the connector
I have a question about the power automate "Power button clicked"; It is currently delivering a NULL data from the columns I added to it. The output is restricted to {}.
Do I need to publish the table (Power BI) to get the power button function work properly? Or do I need a power automate license?
Any feedback would greatly appreciated
Awesome video! Would love to see a video on how to use power automate to select an item in a power bi report, and ask the user to come back into that same power bi report and fill in some comments in a power app visual. For example, why is this item not done yet?
Thanks Sam. That is an interesting scenario.
I am building a similar scenario like this at the moment. I am using a Power App within the Power BI Report which enables the users to add data to the dataset via Excel. The Power BI Dataset Refresh action is used to sync the Excel workbook and the dataset. The source of the dataset is the workbook. I will post a video of the solution on my channel once it is done : ruclips.net/channel/UCLGfygRlwhsekVv7UiRhwXw
Please subscribe to get notified about it.
Just what I was waiting for...
This was awesome brother. Thanks a lot for such a lovely content.
Hi Patrick, Does The Power Automate Features available free for power bi pro users ?
Hi Guy in a Cube, I really enjoyed this video. I have a question though. How can I send an automated power bi report that shows the daily transactions(real-time)
Can we trigger this when the Power BI refresh button is clicked instead of a seperate button as send mail ?
Hey Guy in Cube, i want have an email button to open a new empty email from power bi to be sent to deferent email users depends on selection, can i do this ?
Amazing & super simply explained video..
Can we configure the sender's email?
This is awesome!!! It will help me save a lot of time!!
I had just a question, hoping you answer me or make a video about it 😆 when I tried running my flow, I got the error "manual failed". I set conditions before the action of sending the email, so not sure if that's the issue ☹
Please do more videos on creative ways to use this awesome feature!
Is this possible if the report is published in the app?
How about - if need to send a table showing detail from PBI Tab instead of just plain text?
Is there a way to get the power bi dataset row count without looping through the whole dataset?
For your example, how do you stop the user from sending hundreds of emails?
Great video! Is it possible to also add visuals to the email using this process?
I love this new visual, currently setting up a report that people can use it for to pre-populate some people review forms. I just wish the permissions for running the flow could be a bit smarter. I'd ideally love to be able to either give access to run it to everyone in my organisation and/or everyone who has access to the report. Just a slight pain that I'll have to manage another security list for something that is only ever going to be embedded in a report that I already control access to anyway.
As you say, I'm not lazy, just efficient lol
Is it possible to add a warning message before the trigger gets activated ?
Hello, I'm just wondering what happens if the customer replies to the email they received from Power automate? Who receives the email? Would it go to the Power Automate department in Microsoft?
Just became a member!! Great video but what map viz is that?! Super clean!
can we do this to send emails of the visuals automatically to Slack channels?
That's awesome feature in power Bi..
Q: First of all thanks for sharing your skills. I am wondering how to make the Power Automate flow send an email from the account of the person who triggers it. As ehen I tried, the person who is triggering is using my mail to send. Could you please help?
Hi i have a powerbi report and 40 customers. i separeted the customer different sheet.
how can i send report automaticly to customer.
thanks
Superb video; very clear. Thank you.
I don't have the option of Power BI Data EmailAddress - only User email, which I can't get to work. Any advice?
Hey Patrick, Could you do a video about how to add a warning message when trigger power automate button
how you related the button to the table below which has email...I am finding tough to generate the link
Hey Padrik, Can we directly send an already setup visualization page not the fields to mails by using Power Automate!!!!! , I was struggling in presentations in everyday for each team performance by selecting the each team in a slicer.
Thats awesome we can create automate flow inside the context of Power BI. But when I try to trigger that flow from sharepoint published report it will not be triggered where it will work fine from Power BI desktop. Do you have any idea ?
Great video, Patrick. Can you explain/make a video on how you would implement Power Automate flow within an embedded Power BI Report? How can you enable external users of the embedded report to trigger the flow? When you don't know their email address?
is it possible to disable the button based on a field value?
Excellent video!! Can you make a video of using power automate to send email with excel file attached from PI but it has a slicer with filters?
Do you have to enable power automate or something? When I click edit I get the blue bar at the top that says Microsoft power automate but then nothing else happens
Hi Patrick
I tried to create site attendance record using this visual, is there any way we can add location?
Thank you Patrick for sharing the knowledge.
I have used this real world scenario at my work. Inorder to take it to next level, currently we are able to show numbers (from Measures) in Mail. My query is that, can we include Visuals in the customized mail which is triggered.
fan dabby bleedin dozy! love this Patrick. Very simple when you explain it that well. Thanks!
Hey Patrick. How about if you want to send the snapshot of the report via e-mail. Can you do that?
Can you make scheduling export pdf for personal bookmarks to email in power automate? For viewers role?
Hi Patrick, thanks for the video! Does it only work with outlook, or it works with other email clients as well?
Basically wanted to check if user email client has anything to with it or not...
@@rishirajdeb Use the "Gmail Send Email (V2)" action.
Hi, Patrick... I was attempting to follow your video, and sending emails should be straightforward. However, I'm encountering an issue with the "Power BI Button clicked" step. It seems to have a null output, even though I selected one column from my dataset. Have you encountered this before? I'm wondering if you have any insights on why this might be happening.
Thanks you so much need more videos on this