topic Re: Need help to define the approach for requirement in Developer

Need help to define the approach for requirement

Ravivarma316 — Tue, 15 Dec 2020 11:48:21 GMT

Hello Guys,

Looking for below functionality in our web application.

Here is the list of items which we would like to implement.
1) We would like to see live data in report
2) When user login they can see only their data Dynamic RLS applied in report.
3) Embed the report in Web app
4) Assigned user role when new user will be added in web app.

So can you please guide which approach is the best in terms of Data in Direct Query for live report, License type should be pro or premium capacity, Embedded approach has App owns data or user owns data...

Thanks

Re: Need help to define the approach for requirement

lbendlin — Tue, 22 Dec 2020 14:51:36 GMT

1. assuming your data lives in database tables (and not in a cube) you will want to go for Direct Query connection

2. Your data model will define what individual users can see. 4. You can implement RLS against distribution lists/groups. That way adding a user to a group will give them the RLS permissions assigned to that group. (You can still decide if you want to do the group assignment at the data source, and use group level RLS, or if you want to let it flow into Power BI and do it via the data model.)

3. Are you expecting any sort of interaction between the web app and the embedded report?