Share point to Fabric · Learn Microsoft Fabric

Share point to Fabric

Hi All, I need some guidance as I am designing this first time in Fabric.

We have several data sources in SharePoint (Excel files) that need to be migrated to Fabric. This data will then be exposed to Power BI for data quality checks. Once we identify the data that requires fixing, the Data Analyst (DA) or Subject Matter Expert (SME) will update the files in SharePoint, which will trigger the workflow again.

Additionally, when the data is in Fabric, we need to maintain its history and versioning so that we can compare new data with the old data at a later time.

Q1 = I'm unsure about the best approach for implementing this solution in Fabric. Should I use DLT, or do I need to set up a proper SQL database?

Q2 = Can I bring data from sharepoint directly to Fabric or should I first bring it to the Storage Account then to Fabric one lake?

2 comments