All you should know about Power Automate Visual in Power BI

preview_player
Показать описание
Welcome to the real-world use cases and scenarios series for Power Automate visual in Power BI. Microsoft recently announced the new Power Automate visual for Power BI Reports. This new functionality opens up lots of flexibility to achieve so many functionalities. We can empower our end users to go from insights to action. Now, we can pass filtered context on our date from our Power BI to Power Automate. During this session, we will talk about how we can integrate this Power Automate custom visual for our Power BI report and talk about all you should know about Power Automate visual for Power BI.

Here, first, we will talk about the business scenario:
I want to post a message to my Twitter when I press the button from my Power BI report. I have one YouTube analytics report in Power BI which shows all videos I have published so far. Now, I want to promote some videos on my Twitter. So, I will filter my Power BI Report and pass my filter context to my Power Automate to post a tweet! Check the full video for more information.

Here, first, we will install the Power Automate visual from the App source. Then add fields and create a Power Automate flow in Power BI. Once Power Automate flow is created, we will apply that flow to Power Automate visual. At last, we need to provide Run Only Permissions for those, who want to run this flow. So, stay tuned throughout the entire video.

During this session, you will clear the following concepts:
1. How to add Power Automate Visual in Power BI?
2. How to use Power Automate inside Power BI?
3. How to call flow from Power BI button click?
4. How to share Power BI flow?
5. Run only Permission for Power BI Report
6. How to Call Power Automate from Power BI?
7. How to Trigger Power Automate flow from Power BI?
8. Integrate Power BI with Power Automate

Chapters:
00:00 Start
01:30 Report View
01:54 Business Scenario for Power Automate and Power BI
02:50 Add Power Automate Visual from App Source
03:45 Adding Power Automate Visual in Power BI
03:55 4 Steps for Power Automate Visual
04:16 Publish Power BI Report
05:16 Step 1: Add Fields
05:54 Step 2: Create Power Automate Flow in Power BI
06:20 Step 3: Create Instant Cloud Flow from Power BI
08:30 Add Compose Action to check OOTB Field Information
09:30 Sep 4: Apply Flow
10:30 Test Flow with Trigger Context
11:00 Check Flow Run
12:16 Important Facts about Power Automate Visual in Power BI
13:05 Formatting for Power Automate Visual
14:38 Permissions for Power Automate Visual for Power BI
15:21 Provide Run Permission to Run Power Automate flor for Power BI User
15:52 Run Only User
17:10 Test Flow Again
17:48 Conclusion and Summary - All you should know about Power Automate Visual
18:38 Subscribe!!

In the next part, we will cover the following business scenarios. If you want me to cover different use cases, please drop your suggestion in the comment section.
✔️ All you should know about Power Automate Visual in Power BI
✔️ Export Data to Excel from Power BI using Power Automate
✔️ Send data back to SQL Server based on Selection data from Power BI
✔️ Send Email Notification for Filtered Data
✔️ Refresh Power BI DS using Power Automate
✔️ Export Data to PDF as Table for Selected data from Power BI

***
Follow me on Instagram:

Looking for Consultancy? Connect Here!

Follow me on all social Media Handles:
****

#PowerBI #PowerAutomate #Flow #MicrosoftFlow #PowerPlatform #PowerAddicts #PowerBIWithDhruvin #DhruvinShah #DigitalDhruvin
Рекомендации по теме
Комментарии
Автор

Hi, 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

VB-pkpp
Автор

Hi Thank you for the video! It is very helpful!
Do you know any work around for the 1000 records limit? Im trying to export CSV files but is capped at 1000 rows

joshuagonzalez
Автор

You know if Power Automate visuals work when the report is share on SharePoint ?

boniercharline
Автор

Hello Dhruvin, Thanks for sharing videos here. Very helpful videos. I really liked the power automate visual. Is it possible to trigger this button automatically? so that we can use this feature as subscription.
I have a business scenario that i need to apply filters on my URL and export the report to shared location. Can you please suggest on this?

Thanks,
Sandhya

sandhyadwh
Автор

good video. Means that if you have 1000 tweets in your datasource you would tweet a thousand times ("apply for each")?

DanielWeikert
Автор

Thank you So Much Dhruvin Sir....I have learnt a lot from your videos and able to crack the interview job and got the new job in market...Sir I want request you to make some videos on cost analysis which will help me and other to learn that skill.


Thanks in advance

Zuheb H.S

zuhebkhan