Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Problems viwing data in Power Bi apps

Good morning to all. Recently I've created a report for people to see their respective data (RLS). I've created a dynamic RLS and created an app in power bi. On my desctop application and on the "A...
Please help
power bi apps
RLS problems
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi, lbendlin.

I've created a table with the permitios. I used a dynamic RLS.

As far as I understand, I don´t need to add users in power BI Service. Either way, I've added a couple of users to see if it could fix the issue. Saddly it does not. The people added on Power Bi Service (that is in the table of permitions) can not see the information.

Thanks in advance for your help

PREVIEW
 
 
 
lbendlin's avatar
lbendlin
Super User
4 years ago

So you are using USERPRINCIPALNAME() in your rules ?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    That is correct, lbendlin.

    I have an "autorization table". In Power Bi desktop, i´ve defined the roles as follow:

    Were "[correo]" is the e mail of the user. Ive tested it, and in my company, thats the name we log in the services.

    PREVIEW
     
     
    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      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?

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.