Power BI and power app: Dynamic Row Level Security

[Rose__123]

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 to look into different approaches, but the one that seems to come closest is to add a Power App into my report, where it is possible for the recipients to add their data, which then also will be added to an Excel file, that only I have access to. But how do I add the same RLS into the Power App? The recipients should only see their own names in the app (and thus only be able to change their own data). I have already added an app to my report, and as expected the RLS from the report did not affect the view of the app. 

/Katrine

[v-easonf-msft]

Hi,   @Rose__123 

Please check if these posts could help:

Row level Security on Power apps 

Row-level-security-in-Powerapps-based-on-group 

Configure security using table permissions 

Best Regards,
Community Support Team _ Eason

[lbendlin]

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]

@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]

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]

@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?

[lbendlin]

Yes, the standard PowerApp meta data doesn't know about the capability to initiate a PowerBI dataset refresh. I expect this to be corrected in the future.