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
lbendlin's avatar
lbendlin
Super User
4 years ago

Did you add the users to the role in the Power BI service?

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?