For the CFO, IT and data teams

Microsoft Fabric: data from your ERP, Dynamics 365 and SQL databases in one place, for reports and for AI agents.

Microsoft Fabric brings data from your ERP, Dynamics 365, Dataverse and SQL databases into OneLake, through mirroring and shortcuts, without building export pipelines from scratch. Power BI reports, apps and AI agents read the same tables, with the same permissions.

What we build on Microsoft Fabric

One data estate, read the same way by reports, apps and agents. We start from the decisions you make, then choose the sources.

  • Your sources in OneLake

    SQL Server and Azure SQL databases replicated continuously through mirroring, Dataverse and Dynamics 365 through the built-in Fabric link, files in other stores through shortcuts.

  • Lakehouse and warehouse

    Cleaned, unified tables in Delta format, queried from SQL, notebooks and Power BI.

  • Power BI in Direct Lake

    Reports read the tables directly from OneLake, with no scheduled import and no second copy of the data.

  • Data for agents

    The semantic model and the OneLake tables, available to Microsoft 365 Copilot, Copilot Studio and Microsoft Foundry through Fabric IQ.

  • Access and governance

    Workspace and table permissions, Purview sensitivity labels and the OneLake catalog, with the lineage of every table.

  • Right-sized capacity

    The Fabric capacity sized to your data volume and number of users, with the cost estimated before you buy.

How we build on Microsoft Fabric

Decisions first, then sources, then the model and the reports.

  1. 01

    The decisions

    Which decisions are made, and from which data.

    • Teams
  2. 02

    The sources

    Which systems go into OneLake, and how, through mirroring, a shortcut or a pipeline.

    • ERP
    • Dataverse
  3. 03

    The model

    The lakehouse, the semantic model and the security roles, defined once.

    • Power BI
  4. 04

    Go-live

    Reports in Teams and on mobile, data for apps and for agents.

    • Teams
    • Power BI
    • Copilot Studio

Frequently asked questions

What is Microsoft Fabric?

Microsoft's data platform. OneLake is the single data lake, and data ingestion, lakehouse, warehouse, real-time analytics and Power BI run on top of it, under one capacity and one administration.

Do we need Fabric if we already have Power BI?

Not always. For a few sources and small volumes, Power BI is enough. Fabric makes sense when data comes from many systems, when volume grows, or when apps and agents need the same tables. We tell you which option fits before you buy licences.

Do we have to move data out of our ERP?

No. Mirroring replicates the database into OneLake continuously, and shortcuts read the data where it is. Your ERP stays the system your teams work in.

How is Fabric paid for?

Through a Fabric capacity in your Azure subscription, pay-as-you-go or reserved for a year. We size it to your data volume and to who reads the reports.

Tell us how many systems your Monday report is pulled from today.

In 30 minutes we go through the process and agree what to prepare before the project.

Denis Stadler
The first call is with Denis Stadler.Founder · AI Architect & Fractional CTO