Data Science Wire

Direct Lake Best Practice: Large Gold Table Used by Multiple Semantic Models

Reddit r/MicrosoftFabric1w4 min read

Hi everyone, I'm looking for some advice on a Fabric / Power BI Direct Lake architecture question. We have a very large Gold layer fact table (e.g., accounting document postings) that is consumed by multiple semantic models. The Gold table is intended to be the central, complete business dataset, so we would prefer not to restrict or modify it for a specific reporting use case. The challenge is that some of the semantic models only need a small subset of the data: Only a few columns out of many available Sometimes only a limited date range Sometimes only specific document types or business are

Read the full story at Reddit r/MicrosoftFabric

More in Analytics Engineering