Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
prathmeshpawar
Regular Visitor

AI skills Integration with custom UI

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.

1 ACCEPTED SOLUTION
v-veshwara-msft
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-veshwara-msft
Community Support
Community Support

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.

v-veshwara-msft
Community Support
Community Support

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.

Helpful resources

Announcements
MarchFBCvideo - carousel

Fabric Monthly Update - March 2025

Check out the March 2025 Fabric update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

"); $(".slidesjs-pagination" ).prependTo(".pagination_sec"); $(".slidesjs-pagination" ).append("
"); $(".slidesjs-play.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-stop.slidesjs-navigation").appendTo(".playpause_sec"); $(".slidesjs-pagination" ).append(""); $(".slidesjs-pagination" ).append(""); } catch(e){ } /* End: This code is added by iTalent as part of iTrack COMPL-455 */ $(".slidesjs-previous.slidesjs-navigation").attr('tabindex', '0'); $(".slidesjs-next.slidesjs-navigation").attr('tabindex', '0'); /* start: This code is added by iTalent as part of iTrack 1859082 */ $('.slidesjs-play.slidesjs-navigation').attr('id','playtitle'); $('.slidesjs-stop.slidesjs-navigation').attr('id','stoptitle'); $('.slidesjs-play.slidesjs-navigation').attr('role','tab'); $('.slidesjs-stop.slidesjs-navigation').attr('role','tab'); $('.slidesjs-play.slidesjs-navigation').attr('aria-describedby','tip1'); $('.slidesjs-stop.slidesjs-navigation').attr('aria-describedby','tip2'); /* End: This code is added by iTalent as part of iTrack 1859082 */ }); $(document).ready(function() { if($("#slides .item").length < 2 ) { /* Fixing Single Slide click issue (commented following code)*/ // $(".item").css("left","0px"); $(".item.slidesjs-slide").attr('style', 'left:0px !important'); $(".slidesjs-stop.slidesjs-navigation").trigger('click'); $(".slidesjs-previous").css("display", "none"); $(".slidesjs-next").css("display", "none"); } var items_length = $(".item.slidesjs-slide").length; $(".slidesjs-pagination-item > button").attr("aria-setsize",items_length); $(".slidesjs-next, .slidesjs-pagination-item button").attr("tabindex","-1"); $(".slidesjs-pagination-item button").attr("role", "tab"); $(".slidesjs-previous").attr("tabindex","-1"); $(".slidesjs-next").attr("aria-hidden","true"); $(".slidesjs-previous").attr("aria-hidden","true"); $(".slidesjs-next").attr("aria-label","Next"); $(".slidesjs-previous").attr("aria-label","Previous"); //$(".slidesjs-stop.slidesjs-navigation").attr("role","button"); //$(".slidesjs-play.slidesjs-navigation").attr("role","button"); $(".slidesjs-pagination").attr("role","tablist").attr("aria-busy","true"); $("li.slidesjs-pagination-item").attr("role","list"); $(".item.slidesjs-slide").attr("tabindex","-1"); $(".item.slidesjs-slide").attr("aria-label","item"); /*$(".slidesjs-stop.slidesjs-navigation").on('click', function() { var itemNumber = parseInt($('.slidesjs-pagination-item > a.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); });*/ $(".slidesjs-stop.slidesjs-navigation, .slidesjs-pagination-item > button").on('click keydown', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); var itemNumber = parseInt($('.slidesjs-pagination-item > button.active').attr('data-slidesjs-item')); $($('.item.slidesjs-slide')[itemNumber]).find('.c-call-to-action').attr('tabindex', '0'); }); $(".slidesjs-play.slidesjs-navigation").on('click', function() { $.each($('.item.slidesjs-slide'),function(i,el){ $(el).find('.c-call-to-action').attr('tabindex', '-1'); }); }); $(".slidesjs-pagination-item button").keyup(function(e){ var keyCode = e.keyCode || e.which; if (keyCode == 9) { e.preventDefault(); $(".slidesjs-stop.slidesjs-navigation").trigger('click').blur(); $("button.active").focus(); } }); $(".slidesjs-play").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-stop").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-play")) { $(".slidesjs-stop").focus(); } } }); $(".slidesjs-stop").on("click",function (event) { if (event.handleObj.type === "click") { $(".slidesjs-play").focus(); } else if(event.handleObj.type === "keydown"){ if (event.which === 13 && $(event.target).hasClass("slidesjs-stop")) { $(".slidesjs-play").focus(); } } }); $(".slidesjs-pagination-item").keydown(function(e){ switch (e.which){ case 37: //left arrow key $(".slidesjs-previous.slidesjs-navigation").trigger('click'); e.preventDefault(); break; case 39: //right arrow key $(".slidesjs-next.slidesjs-navigation").trigger('click'); e.preventDefault(); break; default: return; } $(".slidesjs-pagination-item button.active").focus(); }); }); // Start This code is added by iTalent as part of iTrack 1859082 $(document).ready(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); $("#tip2").attr("aria-hidden","true").addClass("hidden"); $(".slidesjs-stop.slidesjs-navigation, .slidesjs-play.slidesjs-navigation").attr('title', ''); $("a#playtitle").focus(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").mouseover(function(){ $("#tip1").attr("aria-hidden","false").removeClass("hidden"); }); $("a#playtitle").blur(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#playtitle").mouseleave(function(){ $("#tip1").attr("aria-hidden","true").addClass("hidden"); }); $("a#play").keydown(function(ev){ if (ev.which ==27) { $("#tip1").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); $("a#stoptitle").focus(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").mouseover(function(){ $("#tip2").attr("aria-hidden","false").removeClass("hidden"); }); $("a#stoptitle").blur(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").mouseleave(function(){ $("#tip2").attr("aria-hidden","true").addClass("hidden"); }); $("a#stoptitle").keydown(function(ev){ if (ev.which ==27) { $("#tip2").attr("aria-hidden","true").addClass("hidden"); ev.preventDefault(); return false; } }); }); // End This code is added by iTalent as part of iTrack 1859082
Top Solution Authors
Top Kudoed Authors
Users online (1,624)