Microsoft Fabric

​

Overview

The 4MINDS platform integrates with Microsoft Fabric, allowing you to connect your Fabric workspaces and import data directly into your 4MINDS datasets. You can browse and import files from Fabric Lakehouses and query tables from Fabric Warehouses — all from within the 4MINDS interface.

---

​

Getting Started

​

Prerequisites

• A Microsoft account with access to one or more Fabric workspaces
• Appropriate permissions on the Lakehouses or Warehouses you want to access

​

Connecting Your Microsoft Fabric Account

1. Navigate to Settings > Integrations in the 4MINDS platform.
2. Find the Microsoft Fabric integration and click Connect.
3. A Microsoft sign-in window will open. Log in with the Microsoft account that has access to your Fabric workspaces.
4. Grant the requested permissions when prompted. The platform requires access to your Fabric workspaces and data.
5. Once authenticated, the integration will show as Connected along with your Microsoft email address.

Note: The connection uses secure OAuth 2.0 authentication. Your Microsoft password is never stored by 4MINDS. Access tokens are encrypted and refreshed automatically.

​

Disconnecting

To disconnect your Fabric account, go to Settings > Integrations, find Microsoft Fabric, and click Disconnect. This removes your stored credentials and revokes access.

---

​

Working with Lakehouses

A Lakehouse in Microsoft Fabric is a file-based data store. You can browse and import files stored in the Lakehouse’s Files directory.

​

Browsing Lakehouses

1. When creating or updating a dataset, select Microsoft Fabric as the data source.
2. Choose Lakehouses from the root view.
3. You will see a list of all Lakehouses across your Fabric workspaces, grouped by workspace name.
4. Select a Lakehouse to browse its files.

​

Importing Files from a Lakehouse

1. After selecting a Lakehouse, the platform displays all files in its Files directory.
2. Use the search bar to filter files by name.
3. Select one or more files using the checkboxes.
4. Click Add Files to stage them for import into your dataset.

​

Supported File Types

The following file formats can be imported from Lakehouses:

​

File Size Limit

Individual files must be 100 MB or smaller. Files exceeding this limit are filtered out automatically.

---

​

Working with Warehouses

A Warehouse in Microsoft Fabric is a SQL-based data store. You can browse tables and views, and import their data into your 4MINDS datasets.

​

Browsing Warehouses

1. When creating or updating a dataset, select Microsoft Fabric as the data source.
2. Choose Warehouses from the root view.
3. You will see a list of all Warehouses across your Fabric workspaces, grouped by workspace name.
4. Select a Warehouse to view its tables and views.

​

Importing Data from a Warehouse

1. After selecting a Warehouse, you will see a list of all tables and views (excluding system tables).
2. Each entry shows the schema name and table name (e.g., dbo.SalesData).
3. Select one or more tables using the checkboxes.
4. Click Add Files to import the table data into your dataset.

Note: Warehouse table data is imported as CSV. Each import retrieves up to 10,000 rows from the selected table. If a table contains more than 10,000 rows, the import will include the first 10,000 rows.

---

​

Dataset Sync

Once you have imported data from Fabric into a dataset, you can set up automatic syncing to keep your dataset up to date with changes in Fabric.

​

How Sync Works

• Lakehouse sync: The platform periodically checks the connected Lakehouse for new, updated, or removed files and syncs them into your dataset.
• Warehouse sync: The platform re-queries the connected Warehouse tables and updates the dataset with the latest data.

​

Sync Options

• Sync specific items: Sync only selected files or tables.
• Sync all: Automatically pick up new files or tables added to the Lakehouse or Warehouse.

---

​

Navigation & UI Features

​

Breadcrumb Navigation

When browsing Fabric resources, a breadcrumb trail at the top of the view shows your current location (e.g., Fabric > Lakehouses > My Lakehouse > Files). Click any breadcrumb segment to navigate back to that level.

​

Multi-Select

Use checkboxes to select multiple files or tables at once for bulk import.

​

Search

Use the search bar when browsing Lakehouse files to quickly filter by file name.

---

​

Troubleshooting

---

​

Security & Privacy

• OAuth 2.0: Authentication uses industry-standard OAuth 2.0. Your Microsoft credentials are never stored by 4MINDS.
• Encrypted tokens: All access and refresh tokens are encrypted at rest.
• Automatic token refresh: Tokens are refreshed automatically before they expire, so you stay connected without re-authenticating.
• Per-user access: Each user connects their own Microsoft account. Your Fabric connection is not shared with other users on the platform.
• Scoped permissions: The integration only requests the permissions needed to browse and read data from your Fabric workspaces.

---

​

FAQ

Q: Which Fabric workspaces can I access? A: You can access all workspaces where your Microsoft account has at least read permissions. Q: Can I import data from Fabric into an existing dataset? A: Yes. You can add Fabric files and tables to both new and existing datasets, and even combine them with data from other sources. Q: How often does dataset sync run? A: Sync frequency depends on your dataset’s sync configuration. You can also trigger a manual sync at any time. Q: What happens to my data if I disconnect my Fabric account? A: Previously imported data remains in your datasets. However, automatic syncing will stop, and you will not be able to import new data from Fabric until you reconnect. Q: Can I connect multiple Microsoft accounts? A: Each user account on 4MINDS supports one Microsoft Fabric connection at a time. To switch accounts, disconnect the current one and connect with a different Microsoft account.