Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Special holiday offer! You and a friend can attend FabCon with a BOGO code. Supplies are limited. Register now.
When creating column-level security on a table, these columns are no longer usable for users in the group with this limitation.
However, when running a SELECT * statement, the error reveals the ' hidden' columns.
The default SELECT TOP 100 rows error occurs for the same reason.
When you click on the table, it shows an error, but no really understandable message.
I would suggest a code change that detects the column-level security and automatically applies it to the user, preventing this user from ever gaining any knowledge of the hidden columns.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.