AI skills Integration with custom UI

[prathmeshpawar]

Hi Everyone, I have a custom UI and want to integrate AI Skills with my UI, show it as a Chat Interface in my UI
Lets assume we have a Lakehouse Connected with AI skill which has 5 tables, T1, T2, T3, T4, T5
The question I have is, Lets say there are 2 users using my UI, A and B
User A: Has access to T1, T2, T3 tables in the lakehouse
User B: Has access to T4, T5 tables in the lakehouse

I want to give the above user context to the AI skill so that if User A fires a query for T4, It should (No Access or similar output)
If this is possible, then how can it be done?

Thanks and Regards.

[v-veshwara-msft · Accepted solution]

Hi @prathmeshpawar ,
We appreciate you using the Fabric Community for your query!

AI Skills in Microsoft Fabric use the authenticated user's credentials to determine what data they have access to. It identifies the schema of connected data sources based on these permissions and evaluates queries across relational databases (Lakehouse and Warehouse), Power BI datasets (Semantic Models), and KQL databases.
For more details, you can refer to the official documentation: AI skill creation (preview) - Learn how to create an AI skill | Microsoft Learn

Regarding your question,, AI Skills should respect each user’s access permissions when fetching data. In your case, if a user only has access to certain tables in the Lakehouse, the AI Skill will retrieve information only from those tables. If they try to query a table they don’t have access to, the AI Skill won’t return any results for that table, ensuring security boundaries are maintained.
You can find guidance on creating an AI Skill here: Create an AI skill (preview) - Microsoft Fabric | Microsoft Learn

That said, since AI Skills is currently in preview, some functionalities may be limited or subject to change. We recommend keeping an eye on future updates as Microsoft continues to enhance security and access control capabilities.

Hope this helps. Please reach out for further assistance.

If this post helps, please consider 'accepting it as the solution' to assist other community members in finding it more easily. A kudos would also be appreciated!

Best Regards,
Vinay.

[v-veshwara-msft]

Hi @prathmeshpawar ,
Just following up to check if the provided response was helpful. If so please consider marking it as Accepted solution to help the community with similar queries. Please reach out for further assistance.

Best Regards,
Vinay.