Your plan is require different queries for the same data set! this is what you are saying if you are granting select on columns. I can no longer have one query/report where one user runds the query and can see the column level data, and the other user runs the exact same query but the column returns nulls. By making the query fail for users without select rights makes this option unusable, way too much governance/cost. You force the creation and management of views which has less overhead than managing two queries ie two reports for the same purpose. Just make the engine return nulls for columns people don't have access to, don't fail the query, or come up with another approach becuase this one is no bueno. Thanks!
lbendlin
on:
Fabric Copy Activity Upsert Needs Native Audit Col...
on:
Power BI Subscriptions enhancements sorely needed
on:
Ragged Hierarchy Display options in Matrix Visual
miguel
on:
Personalized Source List in Get Data