Forum Discussion
How can I append two existing semantic models into a single table?
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.
Why 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.
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.