Databricks Vs Fabric use case

[Phani1]

Hi Team,

We've noticed that for some use cases, customers are proposing a architecture with

A) Fabric in the Gold layer and reporting in Azure Power BI, while using Databricks for the Bronze and Silver layers. However, we can also have the

B) Gold layer in Databricks and connect to Power BI using the serverless feature, eliminating the need for an additional layer.

Which among these options are better for a given scenario and the reason? kindly share your thoughts on this.

Regards,

Phani

[MariuszK]

Gold layer in Databricks and connect to Power BI - this is a good option.

However, If you need to use some of Fabric capabilities, because your team has preferences to use T-SQL, Direct Lake, Python notebooks, low-code tools like Data Factory. MS Fabric as a gold layer may be an option.

You can integrate Databrick into Fabrick using Databricks mirroring, but this feature is in preview, alternatively you can use short cuts, but if you use mange tables this will be more complicated because names of tables aren't predictive, you need to read them from UC.

To give a recommendation I'd discuses it with a client to understand their use cases.