Forum Discussion

jnjAnil's avatar
jnjAnil
New Member
10 months ago
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...
Need Help
  • anilgavhane's avatar
    anilgavhane
    10 months ago

    Steps to Create a Child Semantic Model from a Superset in Power BI

    1. Publish the Superset Model
      • Build and publish the main semantic model (superset) with all tables, relationships, and measures.
      • This acts as the master dataset.
    2. 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.
    3. 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.
    4. 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's avatar
anilgavhane
Icon for Super User rankSuper User
10 months ago

Steps to Create a Child Semantic Model from a Superset in Power BI

  1. Publish the Superset Model
    • Build and publish the main semantic model (superset) with all tables, relationships, and measures.
    • This acts as the master dataset.
  2. 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.
  3. 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.
  4. 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: