Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Check out the July 2025 Power BI update to learn about new features.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
28 | |
19 | |
19 | |
13 | |
12 |
User | Count |
---|---|
30 | |
22 | |
19 | |
18 | |
16 |