Is RLS what I need?
I'm planning to close down a load of SQL driven .asp pages and replace them with Power BI reports. Currently I make sure that a user gets a unique dataset with a SQL query such as SELECT * FROM Table1 WHERE Field1=USERID. How can I make sure that this functionality is replicated in power BI? Is RLS what I need to use, or something else? And would it be best to apply RLS to one query to select the USERID and then link that query with each of the various other queries which produce various datasets? Thanks