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.
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.
Can someone help me understand what the point of creating a onelake security role and granting access to a subset of tables, but not sharing the sql endpoint? What would be the usecase of that if noone can connect to the lakehouse from a client tool. Just trying to understand the reason why it is there, not trying to be rude.
Shouldn't this function the same as scripting the role, adding users to the role and granting the role access to specific objects (which does work for what I'm trying to do).?