Mirroring SharePoint Lists in Microsoft Fabric: Building a Seamless Data Bridge

In this blog, I will walk you through, how you can mirror a SharePoint List in Microsoft Fabric. We’ll explore why this capability matters and how it simplifies collaboration and the practical steps to get started. Whether you are a data engineer, analyst or simply curious about Fabric evolving ecosystem, this guide will help you unlock new possibilities by bridging SharePoint and Fabric with ease.

Prerequisites:

1. A Valid SharePoint License
2. A Microsoft Fabric Paid or Trail License
3. Knowledge on SQL

Scenario Overview:

In this example, we have a SharePoint Communication Site containing two lists:

• Bike_Sales_JantoMar
• Bike_Sales_AprtoJun2021

Our goal is to mirror these lists into Microsoft Fabric for analytics and reporting.

 

1. Create a Mirrored SharePoint Connection

 

I’ve my SharePoint list in my SharePoint(https://ksrconsultingservices.sharepoint.com/)  under Communication site. My requirement is to mirror the two lists such as Bike_Sales_JantoMar and Bike_Sales_AprtoJun2021

 

This is my workspace SharePointList_Mirroring_WS. Click on +New item , search for sharepoint and select Mirrored SharePoint Online List(preview)

Click on SharePoint Online List

2. Connect to SharePoint

Click on Site URL dropdown and select Communication site

 

Fill the form and click on Connect

 

 

3. Select Lists to Mirror

Select the SharePoint lists(Bike_Sales_JantoMar and Bike_Sales_AprtoJun2021) which I need to mirror in Fabric, then we can see preview and click on Connect.

 

4. Create the Mirrored Database

Name your destination with good name(sharepoint2fabric) and click on Create mirrored database

 

Now it’s creating mirrored database

No data has landed, click on refresh to view the status

 

5. Monitor Data Replication

After clicking on refresh, you would see the SharePoint lists as tables, rows reflected and last completed under Monitor replication.

6. Validate Real-Time Sync

Now let me add few details(adding new row) in the both the lists

 

One row increase in both the SharePoint lists

                                                                                                            

Now refresh in Fabric Mirrored database, one row reflected in each table and Last completed updated as well.

7. Query Data Using SQL Endpoint

Click on Mirrored database and select SQL analytics endpoint to query the data

 

You will be seeing  Mirrored database SQL analytics endpoint, tables. Click on new SQL query

Querying the tables Bike_Sales_JantoMar and Bike_Sales_AprtoJun2021

 

Now Created a view on top of this and will pass this to down streams for reporting

 

Limitations (Preview Feature) :

Since this feature is currently in preview, keep the following in mind:

1. Functionality may evolve, and some features are still limited
2. Data is read-only in Fabric (no write-back to SharePoint)
3. Limited transformation capabilities compared to ETL pipelines
4. Supports Communication Sites only (Team Sites not yet supported)

 

Final Thoughts:

Mirroring SharePoint Lists into Microsoft Fabric is a game-changer for simplifying data integration. It eliminates the need for traditional pipelines while enabling near real-time analytics directly from operational data sources.

 

This approach allows you to:

• Focus on insights instead of infrastructure
• Accelerate reporting workflows
• Enable better collaboration between business and technical teams

As Microsoft Fabric continues to evolve, features like this highlight a clear vision: a unified, seamlessly connected data ecosystem.

 

If you found this helpful, feel free to give a Kudo  and share your thoughts in the comments!

 

Happy Learning!

 

Inturi Suparna Babu

[LinkedIn]