Forum Discussion

AhmedYar's avatar
AhmedYar
Regular Visitor
8 months ago
Solved

How to create a unified dashboard from multiple large Power BI semantic models without data

Hi All, I have five separate Power BI semantic models, each built for a different business use case and containing multiple years of historical data. These models are large, continue to grow monthly...
Need Help
  • MattiaFratello's avatar
    MattiaFratello
    8 months ago

    Hi AhmedYar,

     

    I would suggest to use Power BI composite models to connect live to the existing semantic models via DirectQuery, pulling only the selected key metrics into a thin new model for the consolidated tabular dashboard. This reuses models as-is without data duplication or full re-extracts, leveraging monthly refreshes from the source models.

     

     




    Proud to Be a SuperUser ✨
    If this helped, please mark as Answer and give kudos 👍
  • mh2587's avatar
    mh2587
    8 months ago

    Extract only the required monthly metrics from each existing semantic model.
    Store these incremental outputs in a central Delta Lake or Fabric Lakehouse table.
    Append new monthly data to this table, creating a consolidated historical dataset.
    Build the Power BI dashboard on top of this table for a unified view.
    This approach avoids full data reloads, is scalable, and preserves existing models.

mh2587's avatar
mh2587
Icon for Super User rankSuper User
8 months ago

Extract only the required monthly metrics from each existing semantic model.
Store these incremental outputs in a central Delta Lake or Fabric Lakehouse table.
Append new monthly data to this table, creating a consolidated historical dataset.
Build the Power BI dashboard on top of this table for a unified view.
This approach avoids full data reloads, is scalable, and preserves existing models.