Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 names the columns "TableName.ColumnName", which I've kept.
So a role I'm testing on a user looks like this:
= [TableName.ColumnName] = 13
Where the column is an ID column. I'd eventually like to reference USERNAME and implement user security, but I'm just trying to get this to work. However, the above rule will cause a blank report for the user.
I'll add that the above syntax will create red squiggly syntax error lines in the DAX input screen. The only way to get ride of these syntax errors is to create a rule like this:
= [ColumnName] = 13
Which omits the TableName, even though the TableName is part of the column name. This also creates a blank report.
Solved! Go to Solution.
Sorry, yes, I justed checked and the actual input should be:
TableName[ColumnName] = "text"
Without the leading "=" sign, my bad.
Hello All,
Please find the link of the webinar below which we have conducted on RLS in Power BI
I 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.
Hi @mcarper, does it work if you drop the '=' prefix.
For example, put this in the rule:
[ColumnName] = 13
Sorry, yes, I justed checked and the actual input should be:
TableName[ColumnName] = "text"
Without the leading "=" sign, my bad.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.