interact with a Fabric data agent with minimum permission

Hi AntoineW 

I’ve found a solution!

Normally, when we assign the Viewer role to a user, SQL endpoint access is automatically enabled, allowing the Fabric Data Agent to query the Warehouse or Lakehouse.

However, if we don’t want to assign the Viewer role to a user who needs to interact with the Fabric Data Agent, we can simply grant SELECT permissions on the required data source instead.

I would like to add my semantic model to fabric data agent to see what will be happend!

Hi elhammazizi,

Thank you for reaching out to the Microsoft Fabric Forum Community, and special thanks to AntoineW  and BhaveshPatel for prompt and helpful responses.

Could you please mark the working response as the accepted solution? This will help others in the community who are facing a similar issue to find it more easily.

Thanks & Regards,

Prasanna Kumar