Another excellent and useful tutorial from you Reza. Thanks a lot!
@RezaDorrani
3 жыл бұрын
My pleasure!
@robofski
3 жыл бұрын
I use Power BI to manage my Power BI licenses and remove licenses from people who are not actually accessing anything in the service. All manually until this button! Now I can click a button and send a custom approval to the user asking if they still need their license, then depending on the option selected I can remove their license or add them to a list of users who requested to keep the license (then if a user appears on the keep list but still doesn't use it I can take other action later!)
@RezaDorrani
3 жыл бұрын
Wow! That's a cool use case.
@VroomGaur
3 жыл бұрын
I continue to be amazed by your content Reza. I find each one of your video incredibly useful to solve user requirements at work.. No other content creator has such precise videos on solving actual practical problems. Thanks!
@RezaDorrani
3 жыл бұрын
Thank You for the amazing feedback
@BiharKiShaan
2 жыл бұрын
Awesome video. Thanks, Reza! Just Quick question. I have created a powerBi dashboard with power automate flow in it. Now, i have passed the dashboard to powerapps canvas screen. And now if I click on runflow, it didn’t trigger anything. I am sure because the flow first action was “On power Bi button clicked”. Can you help me how could I achieved this in my case
@RezaDorrani
2 жыл бұрын
I will have to look at your flow setup in action to provide guidance. I would recommend posting your issue/query with screenshots on the forums at powerusers.microsoft.com
@pkdomo
Жыл бұрын
Awesome video. 1 question. Can we implement PowerBI Automate in such a way that as soon as a new record gets inserted to a input table of the dataset, it will run the flow automatically & create task without any button click?
@RezaDorrani
Жыл бұрын
Im not sure if that is possible with flow. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@pkdomo
Жыл бұрын
@@RezaDorrani Thanks for ur comment. Actually I heard there is some use case to setup data driven alert in power automate. Not sure if this will address what I am looking for. so I asked.
@RezaDorrani
Жыл бұрын
@@pkdomo Im not sure about that. Try checking on forums
@sujisam5508
3 жыл бұрын
Thank you so much Reza! I am learning so many new things in your videos. Please continue to share more videos 😀
@RezaDorrani
3 жыл бұрын
More to come!
@VB-pk6pp
Жыл бұрын
Hi Reza, its a great helpful video thank you. Are you able to do a video to show how to copy a flow visual button to another page and edit the flow also how to add warning dialogue box to warn as the user click on the flow button
@RezaDorrani
Жыл бұрын
I make videos when I receive multiple requests on a topic. Every quarter I ask subscribers for topic suggestions on Community Tab of my channel. Most voted topic ideas get added to my backlog. Make sure to suggest this idea whenever the next topic suggestion post is out.
@lolalola8421
2 жыл бұрын
Very good video! Do you how to export a report in PI using power automate but the report has a slicer with many filters? Can power automate filter the slicer?
@RezaDorrani
2 жыл бұрын
I don’t think it can.
@JavedAli-rt5xv
2 жыл бұрын
Thank you so much Reza for such an informative video! Would like to know more about power automate & Apps so Do you provide individual training or any link of your courses?
@RezaDorrani
2 жыл бұрын
Currently, I do not provide individual trainings for power platform. I am working on an idea of a training portal.
@RezaDorrani
Жыл бұрын
Check channel memberships. I have gone live with a training tier that you can sign up for now. kzitem.infojoin
@mariamelendez3854
2 жыл бұрын
Hi Reza, I watched several of your power automate visuals videos, and they are super helpful. I have followed all your steps to automate a visual with no problem. However, when I run the flow from Power Bi to my email of my visual matrix table, it shows all the columns except the total row. The total row is displayed in the Power Bi visual, but not in the email. The total row is generated from Power Bi, and it is not something that I created. In other words, it is a row with total sum of all the columns that I have. Also, this column is not included in the fields of the ‘power automate data’ section. I wonder if it is possible to automate this visual showing the total row?
@RezaDorrani
2 жыл бұрын
Flow gets the data from the power bi data set only. Totals and all would need to be a part of the data set. You may have to write expressions in flow to create the totals.
@prakash4190
3 жыл бұрын
Thanks Reza! This is really great. In this approach, I am wondering whether we can send email alerts automatically without clicking the "Run flow" button.
@RezaDorrani
3 жыл бұрын
You will have to look at the automated triggers in flow. There is a Power BI alert driven trigger that might be useful.
@adityadeshmukh3150
3 жыл бұрын
As always great video Reza. Thanks for all your efforts to make such videos...!! I have a question, can we get visuals (Graph) in Power automate?
@RezaDorrani
3 жыл бұрын
You can get the data but not the visual. You would need to use Power Apps if you want the visual from Power BI.
@adityadeshmukh3150
3 жыл бұрын
@@RezaDorrani ok I will give a try using Power App. Thank you
@jeansilva9728
3 жыл бұрын
Very good Reza ... I would like to ask a question about another subject ... If I need to automate the sending of e-mails via power automate, and if in the database there are, for example, 60 items applicable to my conditions, this can bring me outbound problems in outlook (30 emails per minute)?
@RezaDorrani
3 жыл бұрын
Each connector has throttling limits. It can bring outbound problems. Check documentation - docs.microsoft.com/en-us/connectors/office365/
@minstreltokunbo
3 жыл бұрын
Thank you for the resources. However, can you use power automate to refresh data where the data source is a SharePoint on-premise?
@RezaDorrani
3 жыл бұрын
I believe it's possible but I have not done any work with on-premises systems since 2015. I will recommend you check on the forums at powerusers.microsoft.com/
@SHAli1474
2 жыл бұрын
You're like Google for PowerApps, I got a question you got a video :) Thanks Reza.
@RezaDorrani
2 жыл бұрын
Thanks Ali. I try to cover most common scenarios in my videos.
@vladsamoilov897
Жыл бұрын
Same here :). All my KZitem requests re-PowerApps I start with "Reza Dorrani ..." to get the best 😁
@fastjayneel
3 жыл бұрын
Big fan of you Reza, Lots of love and blessings. Your videos have helped a lot in scaling up our skill sets.
@RezaDorrani
3 жыл бұрын
Glad to hear such feedback. Thank you for following my channel.
@karukarthi2609
3 жыл бұрын
Thanks Reza for this video. I keep following your videos and something new to learn as always 🙂 would like to hear more about from spfx & modern list customization as well.
@RezaDorrani
3 жыл бұрын
Thank you for following my channel. Modern List customization - as and when new features come in, I will build scenarios around them. SPFx - I have done very little work on.
@yjamous
2 жыл бұрын
Excellent Video. How can I automate the run of the flow in Power BI? I want to daily capture the date and total sales in SharePoint List. So, how can I do this automated instead of pressing the button everyday?
@RezaDorrani
2 жыл бұрын
In that case you do not need a flow triggering from Power BI. You can create an automated cloud flow that runs on a schedule, connects to your data source to perform the actions you need.
@yjamous
2 жыл бұрын
@@RezaDorrani do you have a video talking about this? I think your videos are very useful and easy to follow.
@RezaDorrani
2 жыл бұрын
@@yjamous I do not have a specific video on this scenario. Check on the forums in case someone has done something similar powerusers.microsoft.com
@Boomtiger47
2 жыл бұрын
Hello, I perform a monthly financial analysis at work. This entails a lot of monotonous work, such as taking screenshots of visualizations in Power BI and manually copying and pasting data from our data models into an email. I then send this email out to whomever needs it. Can Power Automate pull these visualizations exactly how I need them (filtering-wise) and type out the data for me? Ex: Rev YTD is $[enter the revenue YTD from the data model here]. I’m tired of having to type the same things over and over, and I make mistakes all the time lol
@RezaDorrani
2 жыл бұрын
Possible. Using a combination of power bi, flow visual & even desktop flows. I do not have a specific video on this scenario though. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has done something similar.
@awimanu3221
3 жыл бұрын
Once again you nailed it !!! You videos have helped me so much, thank you Reza!
@RezaDorrani
3 жыл бұрын
You are most welcome
@nishantagrawal4954
3 жыл бұрын
Thank you so much... But i have a question...how can i change environment of Power automate from power bi
@RezaDorrani
3 жыл бұрын
Currently, it is not supported.
@Ethan-dd4ln
3 жыл бұрын
Excellent video, Reza. Thank you for the detailed new feature! Subscribed!
@RezaDorrani
3 жыл бұрын
Thanks for the sub!
@eagillum
2 жыл бұрын
Hey man, I can't wait to try this tomorrow. What if you wanted to send a task to SQL to run a report from the power bi button? That would be a bit more complicated. Do you know how to do it?
@RezaDorrani
2 жыл бұрын
I have not tried that but is possible. Would be complicated though.
@rhumeetsinus
2 жыл бұрын
is there a way to make sure that the flow button can only be run by a user, or group of users? can we use RLS with this button? thanks
@RezaDorrani
2 жыл бұрын
Great question. RLS is supported (data passed to flow would be based on user access). Button though would be visible to all users.
@madhukumar3169
3 жыл бұрын
Hi Reza Super content and you have explained very well. What if we want to send this inform to other user id how can we do that. In this video i see i can send this information to only the user ID who is logged in, but what if we need to send this to different user
@RezaDorrani
3 жыл бұрын
In the flow, in the send email action, you can define your users there. You can also get the users from a field in the Power BI Dataset and pass it to the flow. There is no option where user can define a user when calling the flow.
@arshad801
3 жыл бұрын
As always there is something new to learn..thanks Raza
@RezaDorrani
3 жыл бұрын
Glad to hear that
@davidmorris2999
Жыл бұрын
Hi Reza, are you aware of any reason why Power Automate flows will not trigger correctly from an embedded Power BI report on a Sharepoint page? My trigger works beautifully from Power BI Desktop and from Power BI web interface, however when clicking the button on the same report that is embedded on a Share page, the button text changes to "Triggering" and just sits there. Nothing else happens. Checking the 28-day run history of the flow shows it has not been triggered at all, therefore no errors thrown, just no initiation of the trigger at all. Have you seen this same issue yourself? Have you been able to resolve it?
@RezaDorrani
Жыл бұрын
I have not tried this with power bi embedded in sharepoint page. I will recommend checking on the forums at powerusers.microsoft.com/ in case others have experienced something similar.
@sarab_2185
2 жыл бұрын
Great video thank you so much ! I need to build a Power Automate flow that extracts data from a Power Bi report (csv or xlsx) and places the extract in a Sharepoint folder. The flow should be launched automatically every day. I have already created a button in the Power Bi report. When we click on this button, an extract is placed in the Sharepoint folder, but I don't know how to make this flow a scheduled flow. Can you please help me to find a solution for this flow ?
@RezaDorrani
2 жыл бұрын
I do not have a video on this scenario. I would recommend to post your query on the forums at powerusers.microsoft.com. May be someone has done something similar.
@cognosanalytics733
2 жыл бұрын
Same requirement now, it would be helpful if you can share the workaround
@sarab_2185
2 жыл бұрын
@@cognosanalytics733 I did it using paginated report using Power Builder
@cognosanalytics733
2 жыл бұрын
@@sarab_2185 Thank you, yes I build paginatrd report and subscribed to .xlsx format
@sarab_2185
2 жыл бұрын
@@cognosanalytics733 Yes exactly 👍
@japjeetsodhi4820
3 жыл бұрын
Is there a way where the user who clicks the button can send the report to other users - Maybe select the user to whom the report needs to be sent?
@RezaDorrani
3 жыл бұрын
I do not think that is possible at the moment.
@northernboy70
3 жыл бұрын
Amazing video, thank you! Very well demonstrated 😀
@RezaDorrani
3 жыл бұрын
Thank you Peter
@beprovidelo
Жыл бұрын
Reza, how are you! I'm using your video as a base to do my automation! But I have data in a power BI report I would like to action, I have used Power automate to read the data and send an email to the responsibles from this data. If the responsible has multiple rows, they get multiple emails, i.e. 5 rows, 5 emails/messages . Do you know how to solve that?
@RezaDorrani
Жыл бұрын
Dynamic content should have power bi data which is tabular. You can use html action from that point onwards. Similar to kzitem.info/news/bejne/t6SNzWF7qKpkaoY If you need unique values, check kzitem.info/news/bejne/1aZm0ICkpn2UeKg
@jalalsyednaveed5527
3 жыл бұрын
Thank you so much Reza 🙏😊
@RezaDorrani
3 жыл бұрын
Thanks for watching
@hanishvaitla
8 ай бұрын
Hey Reza I have a powerapps form and with each submission, i have a power automate flow running. I want to visualize this in a table, such that all my form submissions have their corresponding flow runs beside. Is this possible ?
@RezaDorrani
8 ай бұрын
Probably possible. I do not have a video reference on this scenario. I recommend checking or posting your query on forums in case someone has done something similar powerusers.microsoft.com
@alzaimoor79
3 жыл бұрын
Thanks for sharing
@RezaDorrani
3 жыл бұрын
Thanks for watching
@rajamahendrareddyvangala114
3 жыл бұрын
Another Great Video Reza! Can you do a video to populate word or excel template or paginated report using power automate in power bi?
@RezaDorrani
3 жыл бұрын
Will add it to my backlog but this is the first request on this topic. I will need a lot more requests on this topic to give this a higher priority.
@foziayimam4159
3 жыл бұрын
Hi Raza! Is it possible in power automate to create a flow which export power bi visual data to excel file format and automate that?
@RezaDorrani
3 жыл бұрын
Yes, there are actions in flow to populate an excel file.
@perrya3550
3 жыл бұрын
Great vid. How about returning data from a flow? My users have been asking for custom excel exports and this seems like this would be the way to do it if the flow could respond with either the file content, or at the very least, a link to the file. I actually built something similar to this using the PowerApps visual. The PowerApp was essentially a button that triggered a flow that built an excel file, and then launched the returned hyperlink. Janky, but it works. This would be a much cleaner solution.
@RezaDorrani
3 жыл бұрын
When you trigger the flow from Power BI, you can build your excel file from flow using the Power BI Dataset, store the excel file (may be in the user's OneDrive) and send an email to the user with the link to the generated excel file. The flow will have the details of the user that clicked the button in Power BI.
@eagillum
2 жыл бұрын
@@RezaDorrani Can you do a video on this?
@RezaDorrani
2 жыл бұрын
@@eagillum I can add this idea to my backlog but I will need a lot more folks requesting this topic in order to give it a higher priority. I frequently ask for video ideas and ask folks to vote on them in the Community Tab of my KZitem channel. Be on the lookout for the next one!
@snehacherukuri1979
3 жыл бұрын
This is very useful for my project, Thank you. But is there any method to increase the export data size from 1000 to 150,000. Please let me know I need this for my current project.
@RezaDorrani
3 жыл бұрын
1000 is the limit of data being transferred to Power Automate from Power BI. You can always directly query your data source in Power Automate to get all records.
@sebastiendebosscher
2 жыл бұрын
For the 1000 record limit 🗳Please vote my ideas on both platforms: ideas.powerbi.com/ideas/idea/?ideaid=3932dcbb-5e6d-ec11-b820-0003ff4569ae powerusers.microsoft.com/t5/Power-Automate-Ideas/increase-power-BI-power-automate-visual-limit/idi-p/1404117#M27489
@chirwatra
Жыл бұрын
Thank you, Do you have a video how to create powerautomate dashboard like in this video ?
@RezaDorrani
Жыл бұрын
Yes kzitem.info/news/bejne/t6SNzWF7qKpkaoY
@chirwatra
Жыл бұрын
@@RezaDorrani Thank you, but i mean create dashboard powerautomate dashboard on PowerBI to show flow status. Same as 0:42
@RezaDorrani
Жыл бұрын
@@chirwatra Power BI is tool to create dashboards not power automate.
@chirwatra
Жыл бұрын
@@RezaDorrani Yeah, i know but the goal is to display PA flow status on PowerBI
@RezaDorrani
Жыл бұрын
@@chirwatra I have not come across this scenario and have no reference videos. I will recommend posting your query on forums at powerusers.microsoft.com
@soyebmalek1536
3 жыл бұрын
Thank you Raza..Great video as always.. I was looking into similar case to trigger flow from PowerBI.. One question, Is it possible to export in ppt for all filter value separately using Power Automate ? For example : In Report, there is a Filter named country (India, Japan, Saudi Arabia) In that case I need to have 3 ppt slides. 1st slide filtered with India, 2nd slide with Japan and 3rd slide with Saudi Arabia. Is it possible using Power Automate ? Any idea Thanks in advance
@RezaDorrani
3 жыл бұрын
Not sure about ppt, but can be places in 3 tables in an excel file or something.
@soyebmalek1536
3 жыл бұрын
Thanks for quick reply. Actually there is option to export as PowerPoint which exports single report with current filtered graph (Basically it export as screenshot/clipboard) similar way i am looking but with all filtered values in separate slides..
@RezaDorrani
3 жыл бұрын
@@soyebmalek1536 Those options are not available in Power Automate.
@revatichaudhari1694
3 жыл бұрын
@@RezaDorrani how to do it in excel can you help me in this?
@RezaDorrani
3 жыл бұрын
@@revatichaudhari1694 I would have to try it out myself to provide guidance. I will recommend you check on the forums at powerusers.microsoft.com/
@sundrapillay6668
3 жыл бұрын
Thanks Reza
@RezaDorrani
3 жыл бұрын
Your most welcome
@samvithb
3 жыл бұрын
Thanks Reza. I tried exporting 2300 rows. The visual is able to push only 1000 rows to CSV. Could you please help ?
@RezaDorrani
3 жыл бұрын
1000 is the limit.
@jaidmansuri4857
2 жыл бұрын
Content is good but can recognise the text on screen.. font is too small.. pls fix that rest is superb
@RezaDorrani
2 жыл бұрын
Will work on zooming into code for future videos. Thanks for the feedback.
@erinfield1943
Жыл бұрын
4:20- "Data coming from Power BI to flow will always come as an ARRAY, so the moment you input a Power BI dynamic content, you will get the Apply to Each experience."
@RezaDorrani
Жыл бұрын
True
@MedariKeshava
Жыл бұрын
Hi Reza, I have one doubt. I create a power BI visual and integrated power automate button into it. My Scenario is when user logs in to power Bi, he clicks on the button - A team chat will be created with other random users. I was able to do it, my challenge is current user able to select button multiple times & group chats are being created every time. Is there any way to restrict users from selecting button multiple times ( but only once ) in Power automate or Power BI condition.
@RezaDorrani
Жыл бұрын
I do not have a video reference on this and would have to try it out to provide guidance. I recommend posting your query on forums in case someone has done something similar powerusers.microsoft.com
@carlostoquica3199
3 жыл бұрын
Good morning Reza, do u have any idea about how to put planner tasks direct to power bi? Do you have any video or documentation of this?
@RezaDorrani
3 жыл бұрын
I will be honest, I have not done much work with planner. But based on my knowledge, you would have to fetch data from planner either as excel export or through Graph API and store it in a dataset from which you could run Power BI reports of. kzitem.info/news/bejne/r51uqmmZs390qI4
@sanprasa1
Жыл бұрын
Hi Reza, I created an Export to excel power automate flow in my power bi dashboard, it works completely fine except it creates file only in my one drive folder not in the users one drive as in my power apps flow does, please advise
@RezaDorrani
Жыл бұрын
I have not come across this issue hence not sure. I will recommend checking on the forums at powerusers.microsoft.com/ in case someone has experienced something similar.
@sanprasa1
Жыл бұрын
@@RezaDorrani Thanks for quick response
@arshiyafatima7188
Жыл бұрын
Hello Reza, I need to run the flow without a button click, maybe on schedular as a trigger, however i am unable to fetch the dataset, can you please help how to fetch the dataset (currently it is coming from on button click trigger) Appreciating your help
@RezaDorrani
Жыл бұрын
kzitem.info/news/bejne/xIpqsJh5pZ19m20
@PadmajaBeere
Жыл бұрын
i have created power bi to power automate task to trigger mail and created outlook while i am clicking Run button is not operating
@RezaDorrani
Жыл бұрын
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
@bertoso
3 жыл бұрын
Reza, is it possible to schedule a stream with power automate to update sharepoint or excel with data coming from power bi? do you have any video like that?
@RezaDorrani
3 жыл бұрын
I dont believe there is a power automate trigger for that. You can manually do so with the power automate visual.
@bertoso
3 жыл бұрын
@@RezaDorrani I understand, I talked to a colleague here at work and he did an atomization started through the run flow button, there is a loop to repeat the task and then a delay, I think it's an option for my need.
@RezaDorrani
3 жыл бұрын
@@bertoso Yes but that's manual. Someone has to click that button :)
@ezharezani5936
3 жыл бұрын
Hi there, how to automate weekly reports in PBI Desktop with same template of visualization?
@RezaDorrani
3 жыл бұрын
This visual is more like a on demand action wherein users will have to click on the button to trigger the flow.
@narenderguguloth9943
3 жыл бұрын
Hi Reza, Filter( Choices('Relationship Type (Accounts)'), !(Value in colChosen.Chosen) ) . In this case what is the relationship type ? And what is the account ??? I am stuck . please help me out . thank you
@RezaDorrani
3 жыл бұрын
I would have to look at your App, setup, tables, relationships etc. to provide any direction. I will recommend you post this query along with screenshots to the forums at powerusers.microsoft.com/
@cmarkbernal
3 жыл бұрын
I'm going to assume that integrating Power Automate does not require the "premium" license for PowerBI?
@RezaDorrani
3 жыл бұрын
When sharing the Power BI report with users, a Power BI license is required.
@jaimesca81
3 жыл бұрын
@@RezaDorrani If I embed the code for publishing in a SharePoint I won't need those visitors to have a Pro License and if try to use that button, it won't run so I assume they are going to need the Pro License anyway :/ (of course to get into this SharePoint site just can do it with the Company's credentials)
@RezaDorrani
3 жыл бұрын
@@jaimesca81 Pro license is required. I believe if you have an E5 license then Pro is included with it.
@revatichaudhari1694
3 жыл бұрын
Is it possible to select all records with high priority and make a excel and sent that into mail.??
@RezaDorrani
3 жыл бұрын
Possible. Passing data from Power BI to flow has a max limit of 2000 items though.
@revatichaudhari1694
3 жыл бұрын
@@RezaDorrani do have some demo link?
@RezaDorrani
3 жыл бұрын
@@revatichaudhari1694 This is the only video I have on this.
@landoftechbuzz3189
2 жыл бұрын
Hello..How to add grand total to the table and how to sort the table .. please help on this..
@RezaDorrani
2 жыл бұрын
I believe if you sort data in power bi and send it should respect it. If not, then you would need to use flow expressions to sort data. Grand total is a risk to calculate in flow since flow will only receive a max of 2000 records from power bi.
@landoftechbuzz3189
2 жыл бұрын
@@RezaDorrani I have tried sort in power bi but it is not working..i have only 15 records after all the filters..if yu have any idea or related video.. please share it.. it was a real time business issue..
@RezaDorrani
2 жыл бұрын
@@landoftechbuzz3189 I do not have a specific video on sorting. Check on forums powerusers.microsoft.com
@thennruvaishnavi7725
3 ай бұрын
Power automate visual of powerbi is not working in when i embed the report to sharepoint online . Can you please make video on it ?
@RezaDorrani
3 ай бұрын
I make videos when I receive multiple requests on a topic. Every 6 months I ask subscribers for topic suggestions on Community Tab of my channel. Most voted idea gets added to my backlog. Make sure to post this idea whenever I post the next topic suggestion post.
@anaaguilar3304
Жыл бұрын
I have two different power automate environments in my job email. Does anyone know how to change the environment so i can create the automation via Power BI. If i try creating the automation via power automate in the correct environment, i can't seem to figure out how to get it to work.. is it possible to get it to work that way ?
@RezaDorrani
Жыл бұрын
I dont think you can change the environment. It has to be the default environment.
@anaaguilar3304
Жыл бұрын
@@RezaDorrani uhh shucks. I'll have to think of a different solution. Thank you for the response!
@RezaDorrani
Жыл бұрын
@@anaaguilar3304 This is a product limitation
@paone333
3 жыл бұрын
Nice
@RezaDorrani
3 жыл бұрын
Thanks
@ogunsolaayobami5324
3 жыл бұрын
hi Reza ,can you pls help with a dynamics sales integration with business central through power automate tutorial
@RezaDorrani
3 жыл бұрын
Hi Ogunsola, I have not done any work with dynamics sales integration with business central. I would recommend you check in the forums to see if someone has done something around this - powerusers.microsoft.com/t5/Microsoft-Power-Automate/ct-p/MPACommunity
Пікірлер: 153