This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
I have a table visual in Power BI and in that table there is a column for salary. How do I get it so that this column shows no data for users who are not approved to see salary data without hiding the entire table? I can't use a measure as the table is too big and the visual doesn't load, I have tried using RLS on the underlying data, but this filters out the entire table visual, and I don't have access to Tabular Editor.
Is this possible?
Hi @JoBen900
I don't think there is an option to achieve this goal without using Tabular Editor / workaroumf with RLS and measure. Note that Tabular Editor is a free application.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 27 | |
| 21 | |
| 20 | |
| 20 | |
| 20 |