RLS issue when publishing dashboard

[Anonymous]

Hello everyone,

I've recently run into a problem with RLS on my dashboard and can't figured it out why this is happening. So, RLS was working just and it started to show malfunctioning after updating my MS Power BI to the newest version (2.126.1261.0 64-bit).

As you can see on the image below RLS is configured on d_Base_Acessos table:

The table d_Base_Acessos has a unique KEY/column so it can filter which information the user will have access to. Below is the relationship between tables:

This is the view with full permision, as you can see the filter CC show all options:

When i simulate the access as another user on desktop things work just fine:

But when this same user tries to access through pbi services, as the dashboard is published, they get the following error:

I've already tried removing and giving access back to them, deleting and uploading again the file into the workspace and creating a new workspace but nothing worked.

PS: the user that tried to access has Viewer access to the workspace and they are registered on the table d_Base_Acessos.

[Anonymous]

Hi @Anonymous ,

Based on the description, the user had Viewer access to the workspace.

When published to the service, click the option and select security.

Add the user to the role.

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

You can also view the following document to learn more information.

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi v-jiewu-msft,

The RLS configured as told before, inside a table on pbi desktop (before publishing), worked just fine.

You are saying that RLS should be necessarily configured on pbi services on the workspace?

[Anonymous · Accepted solution]

Hi @Anonymous ,

The RLS configured on the power bi desktop. After publishing to the service, you should set the security on the semantic model. You can view the following document to learn about RLS steps.

Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

v-jiewu-msft,

I completely understand. But it worked without configuring any RLS rules on pbi service, just by creating the rule on the pbi desktop.

And isn't it strange to register everyone the RLS should be applied to? Shouldn't it just be applied to everyone with viewer level on the workspace? Seems like duplicated work

[ovendoor]

It definitely isn't perfect, but that's the way it works.