Forum Discussion
Need Help: Dynamically Capture Report Metadata from Power BI Button and Email via Power Automate
Hi Kiran_S_S,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to SamWiseOwl, for those inputs on this thread.Thanks for sharing the detailed scenario you can achieve this integration using the Power Automate visual in Power BI to pass parameters directly into your flow, filter your semantic model, and then send an email.
Capture user input from the Power BI button: Use the Power Automate for Power BI (Preview) visual in your report. Add the required fields (Report Name, Workspace Name, Environment) to the visual’s data fields. When the user clicks the button, these fields will be passed to your flow as parameters. Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Learn
Export and email a report with Power Automate - Power BI | Microsoft Learn
Filter your semantic model table in Power Automate: If your table is in Dataverse or another connector that supports filtering, you can use OData Filter Query to retrieve the matching Report ID and Workspace ID. Use lists of rows in flows - Power Automate | Microsoft Learn
Send metadata via Outlook email: Use the Send an email (V2) action in Power Automate, and insert the dynamic content (Report Name, Workspace Name, Environment, Report ID, Workspace ID) into the body. Overview of using Outlook and Power Automate - Power Automate | Microsoft Learn
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi Kiran_S_S,
Thank you for reaching out to the Microsoft fabric community forum. Also, thanks to SamWiseOwl, for those inputs on this thread.
Thanks for sharing the detailed scenario you can achieve this integration using the Power Automate visual in Power BI to pass parameters directly into your flow, filter your semantic model, and then send an email.
Capture user input from the Power BI button: Use the Power Automate for Power BI (Preview) visual in your report. Add the required fields (Report Name, Workspace Name, Environment) to the visual’s data fields. When the user clicks the button, these fields will be passed to your flow as parameters. Integrate Power BI data alerts with Power Automate - Power BI | Microsoft Learn
Export and email a report with Power Automate - Power BI | Microsoft Learn
Filter your semantic model table in Power Automate: If your table is in Dataverse or another connector that supports filtering, you can use OData Filter Query to retrieve the matching Report ID and Workspace ID. Use lists of rows in flows - Power Automate | Microsoft Learn
Send metadata via Outlook email: Use the Send an email (V2) action in Power Automate, and insert the dynamic content (Report Name, Workspace Name, Environment, Report ID, Workspace ID) into the body. Overview of using Outlook and Power Automate - Power Automate | Microsoft Learn
Create a Power Automate visual for Power BI - Power BI | Microsoft Learn
Hope this helps clarify things and let me know what you find after giving these steps a try happy to help you investigate this further.
Thank you for using the Microsoft Community Forum.
Hi Kiran_S_S,
Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.Thank you.
Hi Kiran_S_S,
Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.Thank you.
Hi Kiran_S_S,
Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.Thank you.