Forum Discussion

fulljoin's avatar
fulljoin
New Member
10 months ago
Solved

PowerBI unleashed in Slack

Hey everyone, Lately, I’ve been falling in love with the Power BI Semantic Model. The more I work with it, the more it feels like the real deliverable of a data team - dashboards, Excel connections,...
  • v-sgandrathi's avatar
    10 months ago

    Hi fulljoin,

     

    With a data agent in Microsoft Fabric, you can create conversational AI experiences that answer questions about data stored in lakehouses, warehouses, Power BI semantic models, and KQL databases in Fabric. Your colleagues can ask questions in plain English and receive data-driven answers, even if they aren't AI experts or deeply familiar with the data.
    Create a Fabric data agent (preview) - Microsoft Fabric | Microsoft Learn
    Add Power BI semantic model as data source to Fabric data agent - Microsoft Fabric | Microsoft Learn

    Please use this feature to create an agent to query your semantic model

    Combine that with the Python SDK to create a channel in Slack
    Consume Fabric data agent from external applications with Python client SDK - Microsoft Fabric | Microsoft Learn
    This article shows how to use the Python client SDK to add a Fabric data agent to web apps and other clients by using interactive browser authentication.

     

    Thank you.

  • v-sgandrathi's avatar
    v-sgandrathi
    10 months ago

    Hi fulljoin,

     

    That’s a great idea, using Slack to query the Power BI Semantic Model could make insights more accessible and interactive. You’re correct that Fabric Data Agent is best suited for single-tenant environments. For a scalable SaaS solution, consider Power BI Embedded architecture with service principal profiles, the ExecuteQueries REST API, or XMLA endpoints to securely query each customer’s semantic model.

    You can also integrate Fabric Data Agent with Slack Bolt (Python) to preserve conversational context and provide natural language responses.

     

    Thank you.