Forum Discussion
Choosing the right Fabric architecture
- 2 years ago
Hi,
About the architecture, you can use only a few steps for the ETL to go directly to a kimball star-schema, or you have the option to evolve and clean the data step by step, which would be a combination of the medallion architecture with your final single source of truth.
Keep in mind the self-service nature of Power BI may end up "moving" from a single source of truth to data mesh before you expect. If this happens without coordination, you end up with data silos.
About the cost, you buy what are called Fabric Capacities. You buy them on Azure environment. Here is a list of price: https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/
The challenge will be to discover what capacity will be enough for your processing needs.
Kind Regards,Dennes
Hi,
About the architecture, you can use only a few steps for the ETL to go directly to a kimball star-schema, or you have the option to evolve and clean the data step by step, which would be a combination of the medallion architecture with your final single source of truth.
Keep in mind the self-service nature of Power BI may end up "moving" from a single source of truth to data mesh before you expect. If this happens without coordination, you end up with data silos.
About the cost, you buy what are called Fabric Capacities. You buy them on Azure environment. Here is a list of price: https://azure.microsoft.com/en-us/pricing/details/microsoft-fabric/
The challenge will be to discover what capacity will be enough for your processing needs.
Kind Regards,
Dennes
Hi Data-Crunch - Thanks for using Fabric Community,
We havenβt heard from you on the last response and was just checking back to see if your query got resolved? Otherwise, will respond back with the more details and we will try to help.