Microsoft Fabric Shortcuts to SharePoint are a game-changer for anyone managing data in the cloud. With just a few clicks, you can sync CSVs and text files directly into your Lakehouse no pipelines, no code, and no duplication required.
With Microsoft Fabric Shortcuts to SharePoint, you can now connect to your SharePoint data directly, without moving or duplicating files. That means:
- No ETL pipelines
- No duplicated storage
- Live sync with your SharePoint folders
Whether it’s structured data like CSVs or unstructured text files (like customer feedback), Fabric makes it seamless to integrate this data right into your Lakehouse and Power BI environment.
What Are Fabric Shortcuts?
Shortcuts in Fabric are pointers to external data sources like OneDrive or SharePoint that appear as if they’re local managed tables inside your Lakehouse.
You get all the power of Fabric (Delta Lake, SQL endpoint, Power BI connectivity) without ever moving the original files.
Step-by-Step: Connect SharePoint to Fabric with Shortcuts
1. Start with Your SharePoint Folder
Make sure your SharePoint document library contains your data. In this example:
- Folder:
Sales Details - Contents:
- Subfolder with multiple CSVs
- Subfolder with text files (e.g. customer feedback)
2. Open Your Fabric Lakehouse
Go to your Microsoft Fabric workspace and open your Lakehouse.
3. Create a New Shortcut Table
- Click New Table > Shortcut
- Choose SharePoint
- Use an existing connection or paste your SharePoint site URL
- Navigate through the folder structure
- Select the folder (CSV or text files)
- Click Next and Create
4. Automatic Data Parsing
Fabric:
- Detects file types (CSV, TXT)
- Automatically converts CSVs to Delta Lake managed tables
- Applies AI-based sentiment analysis to text files (optional)
AI on Unstructured Data: Sentiment Analysis
When linking to a folder of text files, Fabric offers to automatically extract sentiment using Azure AI.
The result:
- A new managed table containing:
- File names
- Sentiment (positive/neutral/negative)
- Sentence-level breakdowns
No Python, no Azure ML setup. Just click and create.
What Happens When Data Changes?
New CSVs or text files get added? No problem.
Fabric Shortcuts automatically sync:
- New data is detected
- Tables are updated in the background
- No pipelines or triggers required
You can:
- Run a fresh SQL query
- Refresh a Power BI dataset
- See your updated insights automatically
Query the Data with SQL Analytics Endpoint
With the shortcut tables created:
- Open the SQL Analytics Endpoint
- Run complex SQL queries
- Use regex
- Create common table expressions (CTEs)
- Join structured and unstructured data
- Analyze sentiment by order, customer, or time
Visualize in Power BI
Once your Lakehouse tables are ready:
- Connect them to Power BI via Direct Lake or import
- Build reports using sentiment scores and sales data
- Filter by customer sentiment, product feedback, and more
Real-world use case:
- A feedback file was misclassified
- New data was uploaded to SharePoint
- Fabric re-synced automatically
- Power BI reflected the change after refresh
Why This Matters
With Fabric Shortcuts to SharePoint, you eliminate:
- Manual data movement
- Complex pipelines
- Redundant storage
And unlock:
- Real-time insights
- Streamlined data workflows
- AI-enhanced analytics
Learn More About Microsoft Fabric and Power BI
Want to dive deeper into Microsoft Fabric and Power BI shortcuts, Lakehouses, or sentiment analysis?
