Forum Discussion
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
Hi elhammazizi
In Fabric DWH, there is a row-level security feature that requires the use of T-SQL Programming to restrict access programmatically or Use Lakehouse where you should know Python to restrict access.
Fabric Workspace does not restrict data access ( Admin, Members, Contributor or Viewer - They can still see the data ). The only way is either Fabric DWH to restrict the access or Semantic layer in Power BI ( Row level security ) .
thanks for the response but its totally unrelate to the question , question is why we should assign at least viewer role to a user to interact with fabric data agent ?
Hi elhammazizi
With the Viewer role, the data is still visible in Fabric Data Agent unless you are assigning permissions to an end user who doesn't want to know how to use Fabric Software.