Datamarts in Fabric

[tan_thiamhuat]

Beginning October 1, 2025, Power BI datamarts will not be supported and datamarts will be cleaned up from workspaces. To avoid losing your data and breaking reports built on top of datamarts, migrate your datamart to warehouse. To upgrade existing datamarts to Fabric Data Warehouse, follow the steps in this guide.

--> If we store the datamarts in SQL Database, it would be cleaned up too? why do we need to migrate to warehouse? Is warehouse more expensive than the SQL Database? Isn't it make sense to have different datamarts for different departments? than dump everything from different departments into a single data warehouse?

[v-priyankata]

Hi @tan_thiamhuat 

Thank you for reaching out to the Microsoft Fabric Forum Community.

@BhaveshPatel Thanks for the inputs.

I hope the information provided was helpful. If you still have questions, please don't hesitate to reach out to the community.

[v-priyankata]

Hi @tan_thiamhuat 

I wanted to check if you had the opportunity to review the information provided by user. Please feel free to contact us if you have any further questions.

[v-priyankata]

Hi @tan_thiamhuat 

Hope everything’s going smoothly on your end. I wanted to check if the issue got sorted. if you have any other issues please reach community.

[BhaveshPatel · Accepted solution]

Hi @tan_thiamhuat 

Pricing for Fabric Data Warehouse is similar to Power BI Premium P1 Capacity.

Power BI Premium P1 Capacity = Fabric Data Warehouse F64 Capacity = Fabric Lakehouse F64 Capacity = Direct Lake Semantic Model F64 Capacity.

so like wise it is cheaper and affordable than only using Power BI Premium P1 node.