That changes now.

Dataverse—the secure, scalable business apps and data platform behind Microsoft Copilot Studio, Power Apps, and Dynamics 365—is now natively integrated with Microsoft Fabric, the industry-leading big data and analytics platform. This seamless, zero-copy, real-time integration allows organizations to combine operational and analytical data instantly, without replication or ETL. As your data gets updated in Dataverse, data professionals see latest data continuously updated in Fabric. No need to build and manage complex data integrations.

Fabric + Dataverse Better Together

Copilots in Fabric can create rich reports, discover hidden trends, or re-shape data for even more insights – your employees get to harness the power of data, without requiring the organization to seek expert assistance. 

Organizations can act on these insights immediately by building Power Apps, automating workflows in Power Automate, or creating real-time Fabric data agents to drive decisions and actions across the business. It’s a direct path to operational intelligence. 

There’s no need to invest in third-party connectors, spin up big-budget integration projects, or provision heavy infrastructure, no need for ongoing monitoring and maintenance. Organizations can get started with a fully functional trial, pay only for the data they use, and scale as they grow. Most organizations find this approach to be significantly more cost-effective than exporting data and building data warehouses with data pipelines. 

Announcing enhancements to Link to Fabric and Mirrored Dataverse

The feature at the center of this transformation is Link to Fabric in the Power Apps maker portal, which enables real-time connectivity between Dataverse, Power Platform, and Microsoft Fabric without data movement. 

Since launching Link to Fabric in general availability in November 2023, thousands of organizations have adopted the Link to Fabric feature—and it just keeps getting better. Thanks to enhancements in Microsoft’s managed compute infrastructure, we are announcing faster data refreshes for updates in Dataverse in Fabric within a few minutes, delivering near real-time operational insights without impacting critical transactional real-time workloads. This capability will rollout to existing customers in the coming weeks. Businesses eager to participate in the early adoption of this cutting-edge technology can join the forum at aka.ms/FabricLinkforDynamics.

We are also excited to announce Mirrored Dataverse in private preview, a native experience in Fabric which enables data professionals to securely activate Link to Fabric feature in Dataverse from any Fabric workspace, and to combine all their business data with analytical data in Microsoft OneLake. Register for preview at https://aka.ms/MirroredDataverse.

Using OneLake as a unified data foundation, an organization can: 

• Mirror Dataverse into Fabric for secure, instant access—no ETL or replication required 
• Use shortcuts to automate data assimilation from other clouds, such as Amazon and Google, without physically moving it 
• Transform data its own way using low-code tools like Dataflows or advanced capabilities like Spark notebooks and Data Factory 
• Bring SQL skills along for the ride. Fabric speaks T-SQL, so existing scripts and stored procedures are fully supported. 

With Dataverse and Fabric working seamlessly together, business and analytical data are unified, updated in real-time, and available for insights at all times. 

Unlock real time insights and actions with Fabric data agents

While real-time operational dashboards are an important first step, organizations can also harness the power of AI driven data agents to achieve real-time insights and action. Data professionals in Fabric can leverage real-time data integrations and create Fabric data agents (previously known as Fabric AI Skills). These agents act like an AI-powered data analyst—deeply familiar with your unique business data and ready to reason, answer questions, surface insights, or run exploratory research on your behalf. 

There’s no need to source, train, or manage models – just select the data (live from Dataverse via Link to Fabric or any connected source) and the agent is ready. It’s a faster track to building intelligence into operations without requiring advanced AI expertise. 

And just like the rest of the Fabric and Dataverse integration, it’s designed for speed, simplicity, and scale. Organizations can launch a fully functional trial in hours, with no upfront cost, and pay only for the data they use. This fully managed experience means no complex configurations and no disruption to existing workloads. In fact, most customers report a modest 10% increase in all-up data size managed after enabling the feature in production—delivering powerful AI capabilities at a fraction of the cost of traditional real-time data warehouse solutions. 

Using Link to Fabric feature in Dataverse and Fabric Data warehouse, we simplified setup and configuration process, eliminating the need for multiple tools and streamlined data integration, making it easier to monitor and troubleshoot issues.

The transition also removed several data copy steps enhancing efficiency and reducing processing times from 30-40 minutes to 2-3 minutes. This means, our business gets critical data and reports much sooner, and the reports and tasks run much faster. By consolidating all our services into Fabric, we reduced the costs of our data warehouse by over 50% each month.

Lekha Kannoju, Sr. Manager of Business Intelligence, Global IT | CRC Industries, Inc. 

Take action

With business and analytical data now unified in real time, it’s easier than ever to turn insights into impact. Build responsive Power Apps, automate business processes, and empower teams to act confidently—using the freshest data from across your organization via Fabric OneLake. 

Get started today 

Whether you’re a data professional, a low-code maker, or just curious about what’s possible—there’s never been a better time to explore real-time intelligence with Dataverse and Fabric. 

Learn more: 

• Read more: https://aka.ms/Fabric-Con-Blog-2025
• Dive into official docs: Link your Dataverse environment to Microsoft Fabric and unlock deep insights – Power Apps | Microsoft Learn 
• Join the community forum and connect with experts at aka.ms/FabricLinkforDynamics 

Try real-time data warehousing with Link to Fabric today:  

• Create a developer environment with a free Dataverse. 
• Start a free Fabric trial today 

Join the Mirrored Dataverse in private preview. Sign up now at https://aka.ms/MirroredDataverse

The post Real-time data warehousing with Microsoft Dataverse and Fabric zero-copy integration appeared first on Microsoft Power Platform Blog.

We have worked very closely with Power BI team to develop this connector. If you have downloaded the February update of Power BI desktop, you already have access to the connector. Power BI is intimately aware of PowerApps and CDS. The PowerApps CDS connector enables you to leverage key features built into CDS and PowerApps in Power BI.

Important: This feature was available initially as preview to selected customers (or databases, more accurately) based in USA. The preview is now closed. Further details will be provided soon.

Reports reflect real time data

There’s no need to schedule a refresh in Power BI. When the data is updated in CDS, changes are reflected in reports. Reports are interactive and responsive. You can interactively explore CDS data using the capabilities of Power BI.

Power BI respects security policies defined in CDS

When you secure CDS entities using policies for a set of users, the same permissions are applied to Power BI reports. As an author writing Power BI reports, you can only report against the entities to which you have been granted access in CDS. As an author, when you share reports with your peers in PowerBI.com, your peers can only see the data they are allowed to access in CDS. You do not need to secure data explicitly within Power BI.

Power BI is aware of rich data types and relationships defined in CDS

CDS enables makers to define rich data types such as Address, Boolean, and Currency when you add fields to an entity. In addition to rich types, makers can also define a list of values, called picklists. These types are recognized by Power BI as first class data types. For an example, when you report using an address field, Power BI shows a map as a default visualization.

Entities are presented by subject areas (perspectives)

While CDS contains a rich set of entities representing many business areas, as a Report writer, you may be interested in creating reports by focusing on a business question or a subject area. To make it easier to report on a given business question or a subject area, we have organized entities into a set of ready-made subject areas called Perspectives. A perspective offers a “view into data” from a reporting point of view.

At the time of launch, we have categorized the entities in to 10 perspectives as follows.

*You may notice that we have renamed some of the Entities within perspectives to provide better context for business questions.

When you extend the ready-made entities by adding fields, they will be reflected in Power BI desktop under the respective perspective (no pun intended) and you can use them in reports right away.

As we add more ready-made entities into CDS, we will introduce more perspectives that answer valuable business questions. Soon, we will also enable you to define your own perspectives or, extend ready-made perspectives by adding your own entities.

Enabling Power BI integration in PowerApps

So how do you start reporting with Power BI? – during preview, you would need to enable Power BI integration feature using the admin portal in PowerApps (admin.PowerApps.com). If your CDS environment happens to be in a region where this feature is enabled, and if you have been selected for the preview, you will see an option to enable the feature. You need to enable the feature only once per database.

Important: This feature was available initially as preview to selected customers (or databases, more accurately) based in USA. The preview is now closed. Further details will be provided soon.

Click the button to enable the feature and you are ready to go.

Who can write reports

All the makers in your CDS environment can write reports using Power BI desktop. If you wish to restrict data to makers, you can define security policies in CDS and associates makers to the policies. (You can add your report writers as makers or define security policies using the Administration portal in PowerApps)

Before they can start writing reports, they have to login to the PowerApps environment at least once to confirm that they are a maker.

Writing reports

Now let’s write some reports in Power BI desktop. Launch Power BI desktop (November update or later, preferably February update) and select the PowerApps connector shown in the get data menu

If you are already logged into Power BI desktop, you will be asked to choose an environment to report on. If not, system will ask you to login with your school or work (AAD) account.

If you have access to multiple CDS environments, that is, you have been designated as a maker in more than one CDS environment, you need to select the environment you need to report on.

Next you will be shown a list of Perspectives to report on.

On choosing a perspective, you will be shown the list of Entities for reporting.

For more information you can refer to the Power BI blog post here: https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-connector-for-powerapps-common-data-service

Publish CDS reports to PowerBI.com

You can publish the reports to PowerBI.com and share with your peers.

These reports, along with the reports that you create in Power BI, can be can be shared with users in your organization using capabilities of Power BI.

Power BI licensing requirements

As a maker, you can create reports using CDS environments in Power BI desktop without requiring a Power BI license. Makers can also publish their reports to PowerBI.com with a pro or a free license.

Users who view reports built using the PowerApps CDS connector, will require Power BI pro license. If you do not have a Power BI pro license, you can choose to go with a Power BI pro trial license and all the functionality will be available to you.

The post Create Power BI reports and dashboards with PowerApps Common Data Service appeared first on Microsoft Power Platform Blog.