Forum Discussion
Solved
Lakehouse Object Sharing onelake security role
Hello- I have a lakehouse and I want to share two delta tables with users. I don't want them to see anything in the workspace, just query these two tables through the connector or analytics endpoint...
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.
- Option 1: Try provide SQL Endpoint access at lakehouse level
Option 2
- Create a view in warehouse , the underlying base table pointing to lakehouse tables.
- Provide granular level access only to the table itself.
- GRANT SELECT ON OBJECT::dbo.<view_name> TO [[email protected]];
For option 2, can I grant select to the role?
Yes, you can provide group/ role
I did this, and the user is able to connect in Power BI desktop, but not in excel through the sql endpoint
- Glad to see that it worked, it should work in excel via sql endpoint.