I have a bunch of users that can view and create new data using Power Apps (Canvas) forms. They can view all data in Power Bi also.
I want to restrict access to certain data in Power Bi and Power Apps for some users.
All data viewed and created by these users is stored in a SQL Server database. The connection to this SQL DB is made using SQL server authentication (username and password).
My question: What options do I have to restrict creation and viewing of certain data for some users? I know of Row Level Security, AD groups and roles, Power Bi user roles, etc.
I am unsure of the best approach, and when one or the other approach should be taken.