Forum Discussion
Solved
Two Capacities With Same Data
I have two Fabric capacities: one for internal reporting and one for external reporting. The goal of this setup is to avoid having internal users affecting external. As it turns out, the data for...
Then I would recommend loading the data into separate lakehouses.
A lakehouse is tied into a workspace which is tied into a cpacity. For true separation you would need to load your data into two lakehouses, each in separate workspaces, and each workspace in a separate capacity.
Are you running Direct Lake queries or Import Mode?
Direct Lake.
Then I would recommend loading the data into separate lakehouses.
Follow up question on this: I tend to agree with you here. Is there any tool I can use to ensure the Internal and External stay in sync with each other? As stated previously, they will be the same data but only separated for usage concerns. If an update is made to one, the other would need to be updated as well.
