Forum Discussion

contapapo's avatar
contapapo
Frequent Visitor
2 years ago

RLS problem with shared dataset

Hello, I'm new using RLS
I created a dataset with several tables, some linked, others not.
And I created a rule for user to acess some data from the linked tables, the others tables can be acessed wit no restritition.
The I used this dataset to create a report that I added new tables, but this tables and pages are free to all users and no RLS.
The problem is that when I share the report, users can't see anything.

I gave authorization to the users at the report, and added same users at Security pane for dataset
Could you please help me with that?
Thanks 

Need Help

3 Replies

  • contapapo's avatar
    contapapo
    Frequent Visitor
    2 years ago

    More images to help with solution
    The RLS is based on table 'REGION'

    Image from final report settings

    And this from Security pane from dataset

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi contapapo

     

    If the problem is due to the RLS settings, you will not normally get an error like this.

     

    You can check if the RLS is set up correctly in Power BI Desktop first and if it is working properly.

     

    Then you can go to Power BI Service to check whether the connection to the data source is correct, and whether the gateway and the credentials of the data source have been configured correctly.

     

    Regards,

    Nono Chen

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

    • contapapo's avatar
      contapapo
      Frequent Visitor
      2 years ago

      Hi Nono Chen
      Thanks for your reply
      Before splitting dataset and visuals, it worked as a charm.
      When I test only the dataset, It works too 

      For example, here Iberia is Portugal and Spain. Perfect.
      Can't test when I connect the DS to the visual, because can't acces the linked tables (Country) at 'Manage Roles'

      The problem is for sure at web service, maybe it's when I share the report. And can't see where is my mistake