RLS Help

[winter2805]

Hi All,

I'm new in Power BI.

I need to implement RLS but when I create new role and set the filter for my table, the role doesn't work!

I follow the tutorial into documentation page of Power BI.

When I test my role I see all data for the user that I must restrict data.

I use the latest versione of Power BI Desktop and I use the gateway enterprise.

My DB is a SQL SERVER EXPRESS DB.

The role name is Vendor01 and the filter of my table is set as the follow

- table Invoice --> this is table number 4 into list of all table

- [vendorcode] = "S04" <-- this is the extact syntax

Please help me.

[Greg_Deckler]

See this article by @ankitpatira. I believe that when I tested this, I had to use the syntax shown in the article and include the table name. So, in your case, try:

Invoice[vendorcode]="S04"

http://community.powerbi.com/t5/Community-Blog/Row-Level-Security-in-Power-BI/ba-p/31031

[winter2805]

Hi,

I use the syntax that you propose but doesn't work.

When I test the roles with ellipse "Test As Role" my report became empty and all object have "X - View Details" icon.

My e-mail is in a group.

I don't understand the problem.

Another thing: I put VendorCode as report filter also but doesn't work yet.

Can you help me?

[Oluduroj]

When you select test as role, you get two options

 Type in the username in the bot that says enter email address. This should filter your report.