Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

RLS issue when publishing dashboard

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's avatar
    Anonymous
    2 years ago

    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.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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's avatar
      Anonymous
      Not applicable

      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's avatar
        Anonymous
        Not applicable

        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.