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...
Just a thought, and I would classify this as a bandaid solution and would not recommend it unless you need quick ROI on Fabric reporting, but you could create the materialized view in your source SQL server and mirror those into Fabric. It would allow you to do the cleaning and incremental refresh leverage your server's computing power and prevent that from affecting your capacity's compute.
Again, I would not plan this as a long term fix and would aim towards fixing your underlying data structure that is preventing utilization of the raw tables.
Hope the suggestion helps!