{"id":41617,"date":"2025-06-27T14:47:21","date_gmt":"2025-06-27T09:17:21","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=41617"},"modified":"2025-06-27T14:47:21","modified_gmt":"2025-06-27T09:17:21","slug":"building-translytical-flows-in-power-bi-reports","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2025\/06\/building-translytical-flows-in-power-bi-reports\/","title":{"rendered":"Building Translytical Flows in Power BI Reports"},"content":{"rendered":"

\"Building<\/p>\n

Microsoft has introduced Translytical Task Flows (Preview) in Power BI \u2014 a groundbreaking capability that brings transactional actions directly into the analytical environment. With this new feature, users can initiate tasks such as creating, updating, or deleting records, and even trigger automated workflows \u2014 all within a Power BI report. This marks a major shift in Power BI’s functionality, transforming it from a purely analytical tool into a platform that also supports real-time interaction and operational decision-making. By enabling users to move seamlessly from insight to action, Power BI now empowers more dynamic and efficient business processes without the need to switch between applications.<\/p>\n

Let\u2019s explore the following scenario where Translytical Flows in Power BI can add significant value:<\/strong><\/h3>\n

Scenario: Streamlining Lead Qualification for Sales Managers<\/strong><\/h3>\n

A sales manager frequently monitors a Power BI dashboard that aggregates incoming leads from various sources such as web forms, marketing campaigns, and events. This dashboard provides real-time insights into critical lead metrics, including source, score, status, owner, and engagement level.<\/p>\n

Previously, when the manager identified a high-potential lead meeting predefined qualification criteria such as a lead score above 80, confirmed budget, and established contact, they had to switch to Dynamics 365 or another CRM system to manually qualify the lead. This context switching disrupted the analytical workflow, reduced efficiency, and delayed timely follow-ups.<\/p>\n

With the introduction of Translytical Task Flows in Power BI, this process becomes seamless. The sales manager can now take direct action \u2014 such as qualifying the lead\u2014without leaving the Power BI report. This embedded transactional capability not only accelerates decision-making but also ensures a more fluid and productive user experience by integrating insights and actions in one unified interface.<\/p>\n

Step 1: Enabling Required Features for Translytical Actions in Power BI<\/strong><\/h3>\n

Follow the steps below to set up the required features and dependencies that allow Translytical Flows to function.<\/p>\n

Step1<\/strong>: Enable required Power BI Settings.<\/strong><\/h4>\n
    \n
  • Open Power BI desktop.<\/li>\n
  • Click on the Setting icons as displayed below:<\/li>\n<\/ul>\n

    \"Building<\/p>\n

      \n
    • Navigate to Preview Features and activate the option for Translytical Task Flows.<\/li>\n<\/ul>\n

      \"Building<\/p>\n

      Step 2: Enable Required Fabric Settings:<\/strong><\/h4>\n
        \n
      • Open Microsoft Fabric and sign in with an administrator account.<\/li>\n
      • Navigate to Settings and select the Admin Portal located under the Governance and Insights section.<\/li>\n<\/ul>\n

        \"Building<\/p>\n

          \n
        • Go to Tenant Settings, locate User Data Functions, expand the section, and enable the User Data Functions Note: It may take approximately 15 minutes for the changes to take effect.<\/li>\n<\/ul>\n

          \"Building<\/p>\n

          Now the required Power BI desktop and fabric settings have been enabled.<\/p>\n

          Step 2: Set Up User Data Functions in Microsoft Fabric for Translytical Flows<\/strong><\/h4>\n

          After enabling the necessary features in Power BI and Microsoft Fabric, the next step is to create User Data Functions within Fabric. Follow the steps below to configure them properly.<\/p>\n

            \n
          • Open the workspace where you you’d like to create a User Data Function.<\/li>\n<\/ul>\n

            \"Building<\/p>\n

              \n
            • You’ll find a Function Explorer where the code needs to be pasted. It supports the Python 3.11.9 runtime and allows the use of publicly available libraries from PyPI.<\/li>\n
            • Paste the code that implements the lead qualification logic into the editor.<\/li>\n<\/ul>\n

              Code Example: User Data Function<\/strong><\/h3>\n
              import fabric.functions as fn\r\n\r\nimport requests\r\n\r\nimport json\r\n\r\nudf = fn.UserDataFunctions()\r\n\r\n#\u00a0 Function to get OAuth token using Client Credentials Flow\r\n\r\ndef get_token(client_id: str, client_secret: str, tenant_id: str) -> str:\r\n\r\ntoken_url = f\"https:\/\/login.microsoftonline.com\/{tenant_id}\/oauth2\/v2.0\/token\"\r\n\r\nheaders = {\r\n\r\n'Content-Type': 'application\/x-www-form-urlencoded'\r\n\r\n}\r\n\r\nbody = {\r\n\r\n'client_id': client_id,\r\n\r\n'client_secret': client_secret,\r\n\r\n'grant_type': 'client_credentials',\r\n\r\n'scope': '<Environment URL>\/.default'\r\n\r\n}\r\n\r\nresponse = requests.post(token_url, headers=headers, data=body)\r\n\r\nresponse.raise_for_status()\r\n\r\nreturn response.json()['access_token']\r\n\r\n#\u00a0 Main UDF to qualify a lead in D365\r\n\r\n@udf.function()\r\n\r\ndef qualify_lead(topic: str,leadid:str) -> str:\r\n\r\nclient_id = \"<Client ID>\"\r\n\r\nclient_secret = \"<Client Secret>\"\r\n\r\ntenant_id = \"<TenantID>\"\r\n\r\nenvironment_url = \"<Environment URL>\"\r\n\r\ntry:\r\n\r\n# Step 1: Get token\r\n\r\ntoken = get_token(client_id, client_secret, tenant_id)\r\n\r\nheaders = {\r\n\r\n'Authorization': f'Bearer {token}',\r\n\r\n'Accept': 'application\/json',\r\n\r\n'OData-MaxVersion': '4.0',\r\n\r\n'OData-Version': '4.0'\r\n\r\n}\r\n\r\n# Step 3: Update lead (e.g., set statecode = 1)\r\n\r\nupdate_url = f\"{environment_url}\/api\/data\/v9.2\/leads({leadid})\"\r\n\r\npayload = {\r\n\r\n\"statecode\": 1\u00a0 # Example: mark lead as Qualified or Inactive (depending on your config)\r\n\r\n}\r\n\r\n\u00a0\r\n\r\npatch_headers = headers.copy()\r\n\r\npatch_headers[\"Content-Type\"] = \"application\/json\"\r\n\r\npatch_headers[\"If-Match\"] = \"*\"\u00a0 # Optional for force update\r\n\r\npatch_response = requests.patch(update_url, headers=patch_headers, json=payload)\r\n\r\nif patch_response.status_code in [204]:\u00a0 # 204 = success (no content)\r\n\r\nreturn f\"Lead with subject '{topic}' has been Qualified.\"\r\n\r\nelse:\r\n\r\nreturn f\"Failed to update lead: {patch_response.status_code} - {patch_response.text}\"\r\n\r\nexcept requests.exceptions.HTTPError as http_err:\r\n\r\nreturn f\"HTTP error: {str(http_err)}\"\r\n\r\nexcept Exception as e:\r\n\r\nreturn f\"Unexpected error: {str(e)}\"<\/pre>\n