Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

create a reduced model linked to the first

I have a Power BI Premium workspace where I've built a semantic model with 10 years of historical data. Now, I need to create a second semantic model within the same workspace, but this one should only include the last 2 years of data for specific, limited use cases.

 

I want to set up a data pipeline so that whenever the main semantic model refreshes, the secondary model automatically refreshes as well, ensuring both stay synchronized. How can I achieve this without having two independent models that refresh separately?

  • Hi Anonymous 

    Dataflows are great in premium environments, it would have been better if you had a Dataflow in place. In your case you can connect a new power BI desktop to the semantic model via Direct Query AS and filter data .

1 Reply

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

    Dataflows are great in premium environments, it would have been better if you had a Dataflow in place. In your case you can connect a new power BI desktop to the semantic model via Direct Query AS and filter data .