open report error

[ngomes]

I created a page in power bi "Page-Level Security"
this page only shows the menus that the user has access to
this validation is done by the settings in an excel file where you have the user and the page that the user has access to
With the user who created the report, there is no error when opening the report, but when I try to see the report with another user, I get the error

I gave permissions to the users, it still didn't work

someone can help me?

Thanks

[amitchandak]

@ngomes , Can you share the error in text format? Also can share setting table and formula used

[ngomes]

The error when I enter the report with another user

ID de atividade: daedf87e-864c-4283-9199-55bad4c3bf55
ID do Pedido: e94ea874-4f52-9719-335b-80d188efef7a
ID de correlação: 08125a80-e1f8-c13e-daf8-fb197d5a1c1d
Hora: Fri May 06 2022 10:07:57 GMT+0100 (Hora de verão da Europa Ocidental)
Versão do serviço: 13.0.18173.56
Versão Cliente: 2204.4.11089-train
URI de Cluster: https://wabi-west-europe-d-primary-redirect.analysis.windows.net/

followed example 

the report filters the pages that the user has access through functions

[Anonymous · Accepted solution]

HI @ngomes,

It seems like you are using RLS with username to apply filter effects.
AFAIK, the RLS feature required you to assign the role to users before they access the report if you are working on the power bi service, or the report contents will not load any data and return the error of 'cant load data'.

Notice:

RLS required the read-permission users and assign roles. If users have edit permission, the RLS will be disabled and the error should not be displayed.

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

Regards,

Xiaoxin Sheng