Forum Discussion

akj2784's avatar
akj2784
Post Partisan
8 years ago

Data level security on Power BI

Hi All,   I have data as below .     When Akash logs in, the dashboard should default to Pm Code = 1234, when Ajay logs in, it should default to Pm Code =3234 And it should not prompt user ...
Need Help
bsas's avatar
bsas
Post Patron
8 years ago

   

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Sure there is. You just need another column with the user's Microsoft username (usually their email address but it depends on your Office 365 setup). Then you enable row level security and set a filter there for UserTable[MSUsername] = USERNAME(). Publish the report, add all the users to this role on the service and you're all set.