Forum Discussion
Problems viwing data in Power Bi apps
Next step is to check your data model. Is the authorization table sitting at the edge of the data model pointing all the way to the fact tables in the middle?
Let me show you the conections of each table:
"Tasignación" is the table that contains the data.
"Listas" is a table that contains information of the worker
"Autorización" is the table buil to have the data for authorization.
With this connection, when I "test as Role" it works justfine... but at the time of the truth, the end user cannot see the data.
You can not have other tables influencing your RLS table. That will negate RLS completely.
I don´t understand.
How shoul i solve this issue, then?
I appreciate your help
Change all your bidirectional arrows to single direction from the authorization table all the way down to the facts you want to protect/impact with RLS.