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...
As Taylor Amy mentioned, don't rush to a solution. It's not one single word answer for your case. Here are some things I can point out.
1. Keep the Bronze layer.
2. Start setup the Silver layer & build the notebook to process the data in Joins. Keep Fact and Dim tables at transaction level and define retention policy.
3. Build Gold layer with aggregations and make sure no fallback to direct query. Some of the models can be import mode it I requires once or day refresh with set of tables.
Remeber you can't achieve one gold layer table for all reports requirements.