Forum Discussion
Solved
How can I append two existing semantic models into a single table?
Greetings, I have two existing semantic models of financial data with different refresh schedules. Basically, one is data from the last 1-2 years and is refreshed hourly, and the other one is dat...
You can do selective refresh inside a semantic model, down to the partition level. Or you could consider using dataflows that can have their own refresh cadence.
lbendlin
Super User
Super UserWhy do you want to append them? What visuals are you planning to use the data in, and how?
Our reporting would span multiple fiscal years, mostly revenue and expense comparisons. Separating the data in the first place is really to control the refreshes, as the most recent fiscal years would need updated more often. Older fiscal years might still need updates, but less frequently, and the volume of data is significant enough that we wouldn't want to refresh it more than we need.