Forum Discussion

Rose__123's avatar
Rose__123
Helper II
4 years ago

Power BI and power app: Dynamic Row Level Security

Hi I have a report that should be shared with +20 people, where all of them should only see their own data. But I also want all of them to be able to add data to an excel sheet.  I have tried t...
Need Help
lbendlin's avatar
lbendlin
Super User
4 years ago

Since you already have RLS in your report you can use the identifier field (likely user email) as one of the source fields for the PowerApps visual.

  • Rose__123's avatar
    Rose__123
    Helper II
    4 years ago

    lbendlin, I tried that, but it does not seem to work. I have made a simple app, with the user-email of the sources, but when when I test a role in Power Bi Desktop, it does not filter the app, but everything else is filtered. 
    Do you have any idea why that could be? 

    • lbendlin's avatar
      lbendlin
      Super User
      4 years ago

      remember that when you test in Power BI Desktop you need to specify BOTH the role to test AND the user email you want to test for.

      • Rose__123's avatar
        Rose__123
        Helper II
        4 years ago

        lbendlin I also did that and it works for the rest of the report. However, I tried to make the app from inside Power BI by clicking "create app" instead of using the already made app. When doing so, the data was suddenly filtering, however, inside the app I don't get all the data.  I probably have to look more into how to make the app. 

        It does not make sense to me, why there should be a difference in whether the app is created one or the other way. Do you know why?