Forum Discussion
PowerBI unleashed in Slack
- 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.
- 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.
Thanks v-sgandrathi!
This seems super valuable.
The only part I think you've missed is that I am NOT building this for my own organisation.
I want to build a tool and sell it as a SaaS, in such case your solution does not scale. I could implement this for my customers one by one if they want it to run 'locally' in their own Azure environment.
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.
- v-sgandrathi10 months agoCommunity Support
Hi fulljoin,
Just wanted to follow up and confirm that everything has been going well on this. Please let me know if there’s anything from our end.
Please feel free to reach out Microsoft fabric community forum.- v-sgandrathi10 months agoCommunity Support
Hi fulljoin,
We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help.
Thank you.