RLS problem with shared dataset

[contapapo]

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 

[Anonymous]

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]

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

[contapapo]

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