Forum Discussion
Lakehouse Object Sharing onelake security role
Yes. There is no way to hide all data users through Lakehouse . Read all SQL End Point or Lakehouse is the last option in Microsoft Fabric Lakehouse. it is open source linux systems. For that, You need to work in Direct Lake Mode ( Power BI Desktop ) where there is a option of "Make changes to this model" and you can select/ deselect whatever you want. or there is an option of row level security in Power BI Service. Microsoft Fabric is a Unified Data where there is only one security at all.
Thank you for reaching out to the Microsoft Fabric Forum Community.
I have tested your scenario.
If you've already shared Lakehouse with the SQL endpoint enabled, then the user will be able to access all the data exposed through that endpoint.
However, if you share the Lakehouse without enabling the SQL endpoint, then the user won’t be able to access the data or query anything, unless they are explicitly granted access through roles or permissions.
Try creating a new Lakehouse for testing and sharing it without enabling the SQL endpoint. This will help you confirm whether the role-based access works as intended when endpoint access is restricted.
Below is a screenshot of the lakehouse without giving any permission to the user.
So, the user cannot access the data in the Lakehouse.
Then I've changed the permission to the same Lakehouse by enabling the permission to the user and now the user can access the data.
If this post helps, then please consider Accept it as a solution to help the other members find it more quickly.
Thank you.