create a reduced model linked to the first

[Lamasta]

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?

[aj1973 · Accepted solution]

Hi @Lamasta 

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 .