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!
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!)
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.
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.
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
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
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?
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
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.
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.
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?
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.
@@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.
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?
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)?
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?
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.
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/
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
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.
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.
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 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 RUclips channel. Be on the lookout for the next one!
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?
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.
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?
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 ?
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.
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
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.
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
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..
@@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
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?
Dynamic content should have power bi data which is tabular. You can use html action from that point onwards. Similar to ruclips.net/video/VnWg-Eox37Q/видео.html If you need unique values, check ruclips.net/video/tp0jLnmKcEs/видео.html
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?
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.
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 ?
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
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.
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.
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
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. ruclips.net/video/Ng8D5czMCuY/видео.html
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.
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
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
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.
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
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."
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 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.
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
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/
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.
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.
@@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..
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 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)
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
Another excellent and useful tutorial from you Reza. Thanks a lot!
My pleasure!
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!
Thank You for the amazing feedback
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!)
Wow! That's a cool use case.
Thank you so much Reza! I am learning so many new things in your videos. Please continue to share more videos 😀
More to come!
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.
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.
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
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
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?
You can get the data but not the visual.
You would need to use Power Apps if you want the visual from Power BI.
@@RezaDorrani ok I will give a try using Power App. Thank you
Big fan of you Reza, Lots of love and blessings. Your videos have helped a lot in scaling up our skill sets.
Glad to hear such feedback. Thank you for following my channel.
You're like Google for PowerApps, I got a question you got a video :)
Thanks Reza.
Thanks Ali. I try to cover most common scenarios in my videos.
Same here :). All my RUclips requests re-PowerApps I start with "Reza Dorrani ..." to get the best 😁
As always there is something new to learn..thanks Raza
Glad to hear that
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?
Currently, I do not provide individual trainings for power platform. I am working on an idea of a training portal.
Check channel memberships. I have gone live with a training tier that you can sign up for now.
ruclips.net/user/rezadorranijoin
Once again you nailed it !!! You videos have helped me so much, thank you Reza!
You are most welcome
Excellent video, Reza. Thank you for the detailed new feature! Subscribed!
Thanks for the sub!
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
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.
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.
You will have to look at the automated triggers in flow. There is a Power BI alert driven trigger that might be useful.
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?
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.
@@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.
@@pkdomo Im not sure about that. Try checking on forums
Amazing video, thank you! Very well demonstrated 😀
Thank you Peter
Thank you so much Reza 🙏😊
Thanks for watching
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?
I don’t think it can.
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)?
Each connector has throttling limits. It can bring outbound problems.
Check documentation - docs.microsoft.com/en-us/connectors/office365/
Another Great Video Reza! Can you do a video to populate word or excel template or paginated report using power automate in power bi?
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.
Thanks for sharing
Thanks for watching
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?
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.
Thank you for the resources. However, can you use power automate to refresh data where the data source is a SharePoint on-premise?
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/
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
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.
Thanks Reza
Your most welcome
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.
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.
@@RezaDorrani Can you do a video on this?
@@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 RUclips channel. Be on the lookout for the next one!
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?
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.
@@RezaDorrani do you have a video talking about this? I think your videos are very useful and easy to follow.
@@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
Thank you so much... But i have a question...how can i change environment of Power automate from power bi
Currently, it is not supported.
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?
I have not tried that but is possible. Would be complicated though.
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 ?
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.
Same requirement now, it would be helpful if you can share the workaround
@@cognosanalytics733 I did it using paginated report using Power Builder
@@sarab_2185 Thank you, yes I build paginatrd report and subscribed to .xlsx format
@@cognosanalytics733 Yes exactly 👍
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
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.
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
Not sure about ppt, but can be places in 3 tables in an excel file or something.
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..
@@soyebmalek1536 Those options are not available in Power Automate.
@@RezaDorrani how to do it in excel can you help me in this?
@@revatichaudhari1694 I would have to try it out myself to provide guidance. I will recommend you check on the forums at powerusers.microsoft.com/
Thank you, Do you have a video how to create powerautomate dashboard like in this video ?
Yes
ruclips.net/video/VnWg-Eox37Q/видео.html
@@RezaDorrani Thank you, but i mean create dashboard powerautomate dashboard on PowerBI to show flow status. Same as 0:42
@@chirwatra Power BI is tool to create dashboards not power automate.
@@RezaDorrani Yeah, i know but the goal is to display PA flow status on PowerBI
@@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
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
Great question. RLS is supported (data passed to flow would be based on user access). Button though would be visible to all users.
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?
Yes, there are actions in flow to populate an excel file.
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?
Dynamic content should have power bi data which is tabular. You can use html action from that point onwards.
Similar to ruclips.net/video/VnWg-Eox37Q/видео.html
If you need unique values, check ruclips.net/video/tp0jLnmKcEs/видео.html
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?
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.
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 ?
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
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.
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.
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
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?
I do not think that is possible at the moment.
Content is good but can recognise the text on screen.. font is too small.. pls fix that rest is superb
Will work on zooming into code for future videos. Thanks for the feedback.
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?
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.
ruclips.net/video/Ng8D5czMCuY/видео.html
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.
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
Thanks Reza. I tried exporting 2300 rows. The visual is able to push only 1000 rows to CSV. Could you please help ?
1000 is the limit.
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
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.
@@RezaDorrani Thanks for quick response
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
ruclips.net/video/cT4JdClkLh8/видео.html
Nice
Thanks
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."
True
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?
I dont believe there is a power automate trigger for that. You can manually do so with the power automate visual.
@@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.
@@bertoso Yes but that's manual. Someone has to click that button :)
i have created power bi to power automate task to trigger mail and created outlook while i am clicking Run button is not operating
I recommend posting your issue with screenshots on the forums at powerusers.microsoft.com
Hi there, how to automate weekly reports in PBI Desktop with same template of visualization?
This visual is more like a on demand action wherein users will have to click on the button to trigger the flow.
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
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/
Power automate visual of powerbi is not working in when i embed the report to sharepoint online . Can you please make video on it ?
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.
Hello..How to add grand total to the table and how to sort the table .. please help on this..
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.
@@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..
@@landoftechbuzz3189 I do not have a specific video on sorting. Check on forums powerusers.microsoft.com
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 ?
I dont think you can change the environment. It has to be the default environment.
@@RezaDorrani uhh shucks. I'll have to think of a different solution. Thank you for the response!
@@anaaguilar3304 This is a product limitation
Is it possible to select all records with high priority and make a excel and sent that into mail.??
Possible. Passing data from Power BI to flow has a max limit of 2000 items though.
@@RezaDorrani do have some demo link?
@@revatichaudhari1694 This is the only video I have on this.
I'm going to assume that integrating Power Automate does not require the "premium" license for PowerBI?
When sharing the Power BI report with users, a Power BI license is required.
@@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)
@@jaimesca81 Pro license is required. I believe if you have an E5 license then Pro is included with it.
hi Reza
,can you pls help with a dynamics sales integration with business central through power automate tutorial
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