Forum Discussion
Solved
Can we break the Power BI semantic model into different subsets
Can we split the Power BI semantic model as a main superset and smaller subsets that contain limited tables. The intent is to create a simplified semantic model for self‑service reporting, where only...
Steps to Create a Child Semantic Model from a Superset in Power BI
- Publish the Superset Model
- Build and publish the main semantic model (superset) with all tables, relationships, and measures.
- This acts as the master dataset.
- Create a New (Blank) Power BI File
- Open Power BI Desktop and start with a blank report.
- Add a dummy/blank table if needed to initialize the model.
- Connect to the Superset Semantic Model
- Use Get Data → Power BI Datasets.
- Select the published superset dataset.
- This establishes a connection to the main model.
- Select Limited Tables (Subset)
- Once connected, you’ll get the option to choose which tables to bring into the child model.
- Import only the required tables/columns for the self‑service scenario.
Note: AI helped me to format this result:
anilgavhane
Super User
Super UserSteps to Create a Child Semantic Model from a Superset in Power BI
- Publish the Superset Model
- Build and publish the main semantic model (superset) with all tables, relationships, and measures.
- This acts as the master dataset.
- Create a New (Blank) Power BI File
- Open Power BI Desktop and start with a blank report.
- Add a dummy/blank table if needed to initialize the model.
- Connect to the Superset Semantic Model
- Use Get Data → Power BI Datasets.
- Select the published superset dataset.
- This establishes a connection to the main model.
- Select Limited Tables (Subset)
- Once connected, you’ll get the option to choose which tables to bring into the child model.
- Import only the required tables/columns for the self‑service scenario.
Note: AI helped me to format this result: