PowerBI Distribution

Thanks , In SSRS days RLS was the go to option ; I am am advocate of controlling access via tables

*I need to take a look at the Data Option 

What got me thinking was the MS Article 

https://docs.microsoft.com/en-ie/power-bi/guidance/rls-guidance

Avoid using RLS, whenever it makes sense to do so. If you have only a small number of simplistic RLS rules that apply static filters, consider publishing multiple datasets instead. None of the datasets define roles because each dataset contains data for a specific report user audience, which has the same data permissions. Then, create one workspace per audience and assign access permissions to the workspace or app.

For example, a company that has just two sales regions decides to publish a dataset for each sales region to different workspaces. The datasets don't enforce RLS. They do, however, use query parameters to filter source data. This way, the same model is published to each workspace—they just have different dataset parameter values. Salespeople are assigned access to just one of the workspaces (or published apps).