Forum Discussion
Fabric Environment Design Advice
Hi All, I work for a company that will be providing Fabric capacities managed by us on a per-client basis. Currently we have a mirrored Microsoft SQL Server DB connections in place acting as a b...
Hi michaelgambling,
In an environment this complex, I would recommend having a more mature ETL process than relying on views.
This does mean some data duplication as you'd have a notebook that transforms the data, but then you have clean(ish) data for your semantic models to sit on.
It would be great if we could just layer views on top of views, but in reality that is never going to perform well even if it did work.
THis probably isn't the answer you wanted, but I hope it helps.