Hello Team,
The current option of implement One Lake security at Row/Column level is not working for SQL end point. Is this feature on the Microsoft Fabric roadmap. Most of the business users connect to Lakehouse tables from Power BI desktop, excel or SSMS using SQL endpoint. Current it is available only through SQL grant command. This feature will benefit IT team to have better governance and control on the Lakehouse data.
1 Comment
- Hello ravenderetikala For us the OneLake security is working on the SQL analytics endpoint. Users can only see tables and data they have access to. It's important to switch OneLake access mode in the Security settings of the SQL endpoint to "User's identity". But also to only grant Read access to the Lakehouse. Best of luck, John
