This talk by Andy Cutler offers a good starting point for integrating DBT and Fabric, as well as highlights some potential challenges/ opportunities you will face: https://www.youtube.com/watch?v=ZsCp32X6-XQ
Andy goes through Type 2 SCDs (using Snapshot functionality) and Incremental Loading methods for large fact tables.