Microsoft Fabric is a cloud-based SaaS data platform that unifies all of an organisation's core data workloads into a single integrated environment: data integration, data engineering, data warehousing, data science, real-time analytics and business intelligence. Developed by Microsoft and generally available since 2023, Fabric solves the structural problem of modern data architectures - the patchwork of isolated tools, parallel data stores and inconsistent governance models.
At its heart is OneLake: a single, logical data lake for the entire organisation on which all fabric workloads work together. Data no longer needs to be copied, synchronised or transferred to separate systems. It is available once and is immediately ready for pipelines, analyses, reports and AI models.
The collana group is „Microsoft Solutions Partner for Cloud“. This means it holds all six possible Microsoft Solutions Partner designations in the solution areas of AI business solutions, cloud and AI platforms, and security for your digital projects.
Many organisations today run a range of tools in parallel: Azure Data Factory for data integration, Azure Synapse for analytics, Power BI for reporting, Azure Machine Learning for AI models, and separate database services for various use cases. Each tool has its own costs, its own administration and its own security framework.
Microsoft Fabric
Microsoft Fabric replaces this patchwork with a unified platform featuring a common compute model, a shared governance layer via Microsoft Purview, and a unified user interface for all roles – from data engineers to business analysts.
Microsoft Copilot is firmly integrated into all Fabric workloads. It generates SQL queries, creates data pipelines, writes code to notebooks, builds Power BI reports from voice input and summarises data analyses. Teams that previously relied on specialised technical staff can now use Copilot to complete data tasks independently - without having to wait for IT resources.
The introduction of Microsoft Fabric is an architectural decision that fundamentally transforms existing data landscapes. Anyone operating Synapse pipelines, Power BI datasets and Azure Data Factory workflows needs to understand what can be migrated, what should be rebuilt, and how OneLake is integrated into existing data flows.
collana As a certified Microsoft Solutions Partner, it supports organisations with the implementation, migration and day-to-day operation of Microsoft Fabric.
Fabric offers a complete data engineering environment with Spark-based notebooks, data pipelines and the lakehouse concept, which combines the strengths of data lakes and data warehouses. Data from ERP, CRM, IoT and external sources is loaded into OneLake in a structured manner, transformed according to the Medallion architecture and made available for all downstream workloads. collana develops data engineering solutions on fabric: from data architecture and ingestion pipelines to clean modelling.
The Fabric Data Warehouse is a fully managed, elastic data warehouse optimised for SQL workloads and structured data analysis. Thanks to direct-lake mode, Power BI reports can access OneLake data directly, without importing or redundant data storage. Analysts work in familiar SQL environments, while Fabric takes care of all the infrastructure overhead.
Relevant for: Wholesale & foreign trade, Process industry, E-commerce, NPOs & associations, Process industry, Healthcare
Fabric Real-Time Intelligence processes streaming data from IoT devices, web logs, production facilities and transaction systems in real time. Event streams, KQL databases and Data Activator can be used to create real-time dashboards, monitor threshold values and trigger automatic actions when defined events occur. For manufacturing companies, this is the basis for predictive maintenance and real-time operational control.
Relevant for: Production & manufacturing, Process industry, Food industry, Logistics & transport
Fabric provides an integrated data science environment with Spark notebooks, MLflow and Azure machine learning functionalities. Data scientists train models directly on OneLake data without having to export data to separate systems. Predictive analytics models, anomaly detection and demand forecasts are created on the same platform on which the data is stored and analysed.
Relevant for: All industries, especially Wholesale & foreign trade, Production & manufacturing, E-commerce, NPOs & associations, Healthcare
Fabric is fully integrated into Microsoft Purview. Data catalogue, data lineage, access policies and compliance requirements are managed centrally for all workloads. Companies gain a complete view of what data is located where, who has access and how data flows through the entire platform - the basis for GDPR-compliant data processing and regulatory verification.
Relevant for: Healthcare, Authorities & public sector, Process industry, Food industry, all regulated industries
Data Factory, Synapse, Power BI, Azure ML – many organisations currently run these services in parallel, with separate costs, separate administration and constant integration issues between them. Fabric solves this problem at a structural level: one SaaS service, one capacity model, one governance layer.
The operational costs associated with running the data infrastructure are falling significantly.
The principle behind OneLake is simple, and its implications are far-reaching: data is stored once and is immediately available for all Fabric workloads. No data copies between systems, no synchronisation issues, no duplicate storage.
Power BI reports, ML models and SQL queries all run on the same dataset, without any delay or inconsistencies.
Fabric is designed to enable data engineers, data analysts, data scientists and business users to work on the same platform – each with the tools suited to their role. Results from data preparation are immediately available for analysis, whilst models from data science are incorporated directly into reports.
Departmental boundaries in the world of data are therefore a thing of the past.
Copilot is not a feature of Fabric, but is embedded within every single workload. It writes SQL queries, builds data pipelines, generates notebook code and creates Power BI reports from natural language. Teams that previously relied on specialist knowledge are becoming more productive.
And teams that already have experience achieve results more quickly.
Real-Time Intelligence is not a separate product that runs alongside Fabric – it is part of the platform. Streaming data from the IoT, web tracking or transaction systems flows into the same OneLake environment that also contains historical data.
Real-time and batch analyses use a shared dataset.
Integration into Microsoft Purview This means that the data catalogue, access rights, data lineage and compliance policies are configured once and automatically apply to all workloads. For organisations in regulated sectors or those subject to GDPR requirements, this offers a structural advantage over architectures in which each tool requires its own security framework.
Fabric is billed using what are known as ‘Fabric Capacities’ – a standardised capacity model that covers all workloads. Organisations pay for a total capacity rather than for a multitude of individual services with separate pricing plans.
This makes cost planning and budget management significantly easier than in an environment comprising five different Azure PaaS services.
Fabric is explicitly designed as a platform for the AI era. Fabric Data Agents can be used to build AI agents that access OneLake data, recognise patterns and provide context-aware responses.
Anyone who consolidates their database in Fabric today is laying the groundwork for AI applications to run on clean, complete and up-to-date business data.
collana is a six-time certified Microsoft Solutions Partner and fulfils the requirements in several areas of expertise: Business Applications, Data & AI, Digital & App Innovation, Infrastructure, Security and Modern Work. These certifications are not an end in themselves. They prove that we not only know the Microsoft platform, but that we have mastered it at enterprise level and are continuously developing it further.
What distinguishes collana from a pure technology service provider is its understanding of what data really needs to achieve in a company. Whether it's an international BI platform for production companies, marketing data architecture for retailers or centralised data controlling for research institutes: We know the requirements, the typical data quality problems and the points at which standard architectures reach their limits. This knowledge flows into every fabric project right from the start.
Microsoft Fabric is a cloud-based SaaS data platform that combines data integration, data engineering, data warehousing, data science, real-time analyses and Power BI in a single environment. At its centre is OneLake, a unified data lake on which all workloads work together. Companies use Fabric to break down data silos, modernise data architectures, underpin Power BI reports with a more reliable database and build AI applications on clean, integrated enterprise data.
Azure Synapse Analytics is a PaaS solution for big data analyses and data warehousing. Microsoft Fabric is the further development and simplification: a complete SaaS offering that combines Synapse functionalities, Power BI, Azure Data Factory and Azure Machine Learning in a standardised platform. The key difference is the model: Synapse requires independent administration and integration with other Azure services. Fabric provides everything from a single source, with a shared data store (OneLake), a standardised capacity model and a central governance layer.
OneLake is the unified, logical data lake that serves as shared storage for all fabric workloads. It is based on Azure Data Lake Storage Gen2, is set up automatically for each organisation and stores data in open delta parquet format. The key thing about OneLake is the principle: data is stored once and is immediately available for pipelines, notebooks, SQL analyses, Power BI reports and AI models - without copies, without synchronisation, without data loss between systems.
Microsoft Fabric is billed via so-called Fabric Capacities - SKUs such as F2, F4, F8 to F2048, which provide different computing power and cover all workloads. Power BI Premium customers can use their existing capacities for fabric. The total costs depend on the capacity used, the data volume and the workloads deployed. Compared to the separate operation of Synapse, ADF, Power BI Premium and Azure ML, the consolidated fabric costs are more favourable for many companies. A reliable cost estimate can be obtained from a structured requirements analysis with collana.
Yes, Microsoft Fabric has extensive connectors for external source systems, including SAP, Dynamics 365, Salesforce, Oracle and many more. Database mirroring allows operational databases to be mirrored to OneLake in real time without having to set up individual pipelines. Dynamics 365 data from Finance, Supply Chain and Business Central can be integrated directly into Fabric - creating the basis for reporting that brings together operational ERP data and analytical analyses.
Yes, and Fabric's SaaS model makes it particularly attractive for medium-sized companies. Eliminating the separate administration of data engineering, warehouse and BI services significantly reduces IT costs. Companies start with the Fabric capacity that meets their current needs and scale up as their requirements grow. Full integration with Power BI and Microsoft 365 means teams work with familiar tools on a modern data foundation - without a steep learning curve.
Power BI is part of Microsoft Fabric - the business intelligence and visualisation layer of the platform. Fabric is the more comprehensive framework: the data integration, data warehouse, AI modelling and real-time analysis on which Power BI is built. If you only use Power BI, you are working with a subset of Fabric. Introducing Fabric gives Power BI a much stronger, more consistent and easier to maintain database.