Forum Discussion
Solved
Syntax for Row-Level Security
Has anyone gotten the newly available Row-Level Security (Preview) to work? I'm using an imported SSAS Tabular on-premise dataset. When I connect to the tabular model in Desktop, it automatically...
Sorry, yes, I justed checked and the actual input should be:
TableName[ColumnName] = "text"
Without the leading "=" sign, my bad.
Greg_Deckler
Community Champion
Community ChampionI have last night at our Power BI User Group meeting. The syntax I used was DAX:
= TableName[ColumnName] = "text"
I did not try it with a number, but I think it is because you are not referencing the table name in your query.
Weird, I'm trying both 'TableName'[ColumnName] and TableName[ColumName] and neither works.
- orionlee
Microsoft Employee
Hi mcarper, does it work if you drop the '=' prefix.
For example, put this in the rule:
[ColumnName] = 13
- Greg_Deckler
Sorry, yes, I justed checked and the actual input should be:
TableName[ColumnName] = "text"
Without the leading "=" sign, my bad.
