I am trying out methods of creating subsets of already existing datasets in Power BI.
Note: I have PowerBI Premium per user licence
* Problem 1: My users have high demand for the AI feature in PowerBI which is disabled on RLS datasets.
* My solution: Create multiple datasets with filters instead of one dataset with RLS... This raises problem 2
* Problem 2: Maintaining multible datasets, measures, schemantic model and other logic for each dataset will be problematic in future for multiple datasets.
* My solution to this: Create one dataset which will maintain all the measures, schemantic modeling and more and then create multiple subsets of that dataset with filters for security logic.
The way I plan on doing this is to create dataset as usual for the main(unfiltered) dataset and then create subsets by connecting to that dataset using the analysis service connection and applying appropreate filters. This is possible with premium workspaces and XMLA endpoint enabled.
Datasets:
Dataset1 (main)
-Dataset1.1 (filtered main)
-Dataset1.2 (filtered2 main)
-Dataset1.*
Is this best practice or any tips on doing it differently/better?
Using my method - Will the performance depend on the data gateway resources or the power BI service resources?
