Forum Discussion
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
Community 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 .