![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-15.png\")
<\/p>\n<\/p>\n
Fabrics<\/strong> (Microsoft Fabric) is an integrated data platform crafted to enhance data engineering, science, and analytics. It provides a comprehensive range of tools and services to handle every aspect of data operations, from storage and processing to analysis. Microsoft Fabric simplifies the data management workflow by providing a unified environment that allows seamless execution of various data tasks.<\/p>\n Data Activator<\/strong> is a Microsoft Fabric<\/a> feature designed to support real-time monitoring and automate data-driven actions. It enables users to establish rules and triggers based on data changes. When predefined conditions\u2014such as exceeding a data threshold\u2014are met, Data Activator automatically executes predefined actions, such as sending alerts or initiating workflows. This functionality is ideal for proactive data management, ensuring users are promptly informed of significant changes or anomalies.<\/p>\n In organizations that provide services, resolving customer issues through case management is a critical function. Salespersons are tasked with addressing and resolving the cases assigned to them, while Sales Managers observe the progress to ensure all pending cases are managed efficiently.<\/p>\n Consider a scenario where a Sales Manager requires notifications when the number of pending cases for any salesperson reaches a predefined threshold. This system would enable the manager to:<\/p>\n By implementing such a notification system, organizations can enhance their case management processes, ensuring that all cases are addressed on time and that workload distribution remains optimal.<\/p>\n Initially, we developed a Power BI report that provides a comprehensive visualization of case data, incorporating various visuals, calculated columns, and measures enabling users to gain a deeper understanding of key metrics and make informed decisions.<\/p>\n The report includes a calculated column named Exceeded<\/strong>, which identifies users with pending cases exceeding 50<\/strong>. Below is the DAX expression used for the Exceeded<\/strong> column in Power BI:<\/p>\n Exceeded = if<\/span>(contact[Pending Cases]<\/span>>50<\/span>,UNICHAR<\/span>(9650<\/span>),BLANK<\/span>())<\/p>\n Following this, we have developed a measure to calculate the total number of users who have exceeded the case threshold. This measure aggregates the count of users flagged by the Exceeded column, providing a comprehensive overview of users with high case loads.<\/p>\n Exceeding Users = COUNT<\/span>(contact[Exceeded]<\/span>)<\/p>\n Let\u2019s navigate to Power BI Services. If you have not yet created a workspace, create a required Workspace.<\/p>\n However, please ensure that the workspace is assigned a license that supports advanced features, such as Power BI Premium<\/strong> or Power BI Premium Per User (PPU)<\/strong>.<\/p>\n We created a workspace named \u201cD Activator<\/strong>\u201d with a Power BI Premium Per User (PPU)<\/strong> license and published the Power BI report it.<\/p>\n To start adding alerts in Power BI using Data Activator, follow these steps:<\/p>\n In the Case Report<\/strong>, locate the Card Visual displaying the measure called Exceeding Users<\/strong>, which counts the total number of users who have exceeded the threshold. We will use this measure to set up an alert in Data Activator.<\/p>\n The alert condition is configured to notify you when the count of exceeding users changes. This alert will trigger if:<\/p>\n When setting up the alert, ensure you adjust the settings in the Show Save Options<\/strong> to match the same workspace where your Power BI report is located.<\/p>\n After creating the alert, navigate to Data Activator Reflex<\/strong> to enhance functionality with Power Automate Flow.<\/p>\n Follow the number to get the information.<\/p>\n Let’s extend the functionality by adding a custom action in the Reflex.<\/p>\n Add the Additional information<\/p>\n We have successfully added the Power Automate Flow to the Trigger\/Reflex, enabling alerts for exceeding users.<\/p>\n Let’s proceed to the output. Once users exceed the threshold, the flow will send an email that can be formatted as per your requirement.<\/p>\n In this guide, we demonstrated how to use Microsoft Fabric\u2019s Data Activator to automate alerts for exceeding user thresholds in Power BI. We created a Power BI report and set up an alert to notify users when the count of exceeding users changes. This was achieved by configuring the alert in Data Activator and integrating it with Power Automate Flow to perform custom actions, such as sending notifications. This process enhances proactive data management and ensures timely responses to significant changes in case loads, improving overall case management efficiency.<\/p>\n Fabrics (Microsoft Fabric) is an integrated data platform crafted to enhance data engineering, science, and analytics. It provides a comprehensive range of tools and services to handle every aspect of data operations, from storage and processing to analysis. Microsoft Fabric simplifies the data management workflow by providing a unified environment that allows seamless execution of\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":11,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[2917,45],"tags":[2934],"class_list":["post-39147","post","type-post","status-publish","format-standard","hentry","category-power-automate-flow","category-power-bi","tag-data-activator"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/39147","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/11"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=39147"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/39147\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=39147"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=39147"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=39147"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-1.png\")
<\/a><\/p>\n![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-2.png\")
<\/a><\/p>\n\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-3.png\")
<\/a><\/p>\n\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-4.png\")
<\/a><\/p>\n\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-5.png\")
<\/a><\/p>\n\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-6.png\")
<\/a><\/p>\n\n
\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-7.png\")
<\/a><\/p>\n\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-8.png\")
<\/a><\/p>\n\n
\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-9.png\")
<\/a><\/li>\n![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-10.png\")
<\/a><\/li>\n![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-11.png\")
<\/a><\/li>\n\n
![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-12.png\")
<\/a><\/p>\n![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-13.png\")
<\/a><\/p>\n![\"Triggering](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/09\/Triggering-Power-Automate-Flows-with-Data-Activator-14.png\")
<\/a><\/p>\nConclusion<\/strong>:<\/h2>\n
![\"Power](\"https:\/\/www.inogic.com\/blog\/wp-content\/uploads\/2024\/01\/Power-BI.gif\")
<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"