Search

Welcome to Datagrid
Welcome to Datagrid
MS Fabric

MS Fabric

Microsoft Fabric is an all-in-one analytics solution that covers everything from data movement to data science, Real-Time Analytics, and business intelligence. By connecting MS Fabric to Datagrid, you can seamlessly integrate your data across these various domains, enabling enhanced reporting, analysis, and decision-making.

1. How-to

1. Prerequisites

To configure the MS Fabric connector, follow these steps:

  • An active Microsoft Fabric account with the necessary permissions to access the projects and data you want to import into Datagrid.
  • A Microsoft Entra ID app with the necessary permissions to access the Fabric APIs.
  • Fabric REST API enabled.
  • Select the data you want to import into Datagrid

2. Connect

Creating a dataset from the MS Fabric connector involves selecting the specific data you want to import:

  1. Connect MS Fabric App: a. Click on the "+ Create” Button on the top left of the screen. b. Select the "Connect Apps" item. c. Search for the MS Fabric connector from the list. d. Login with your Microsoft Fabric account. MS Fabric may prompt you to authorize Datagrid's access to your data. Grant the necessary permissions to proceed. e. Click on the “Next” button.
  2. Pick your Data: a. Pick the MS Fabric data you want to include in your dataset (e.g., Lakehouses, Data Warehouses, KQL Databases). b. Click on the “Start First Import” Button to start syncing your MS Fabric dataset.

3. Set Up a Schedule

Scheduling regular data pulls ensures your Datagrid datasets remain up-to-date with the latest information from MS Fabric:

  1. Navigate to MS Fabric Dataset: a. Go to the left side panel and locate and click on the MS Fabric dataset you created.
  2. Schedule Settings: a. Click on the “...” on the top right of the dataset. b. Click on “Edit Pipeline” to edit your connector's name. c. Click the “Schedule” button on the right, beside the “Import Configuration” button.
  3. Configure Schedule: a. Set the desired frequency for data pulls (e.g., daily, weekly, monthly). b. Specify the time of day for the data pull to occur. c. Specify downtime if needed – when the sync should not happen. d. Click the “Update” button to update the new configuration.

4. Data Access

  • Lakehouses
  • Data Warehouses
  • KQL Databases
  • Reports
  • Dashboards
  • Datasets

5. Use Cases

  • Real-Time Analytics: Analyze real-time data from various sources using Fabric's Real-Time Analytics capabilities and integrate it with other business data in Datagrid for comprehensive insights.
  • Data Science: Utilize Fabric's data science tools to build machine learning models and integrate the results with other data in Datagrid for predictive analytics and decision-making.
  • Business Intelligence: Create interactive dashboards and reports using Fabric's Power BI integration and combine them with other data sources in Datagrid for a holistic view of your business performance.
  • Data Integration: Seamlessly integrate data from various sources into Fabric's data lake and data warehouse and then connect it to Datagrid for unified data analysis and reporting.

6. FAQ

Q: What is Microsoft Fabric? A: Microsoft Fabric is an all-in-one analytics solution that covers everything from data movement to data science, Real-Time Analytics, and business intelligence.

Q: What type of data can I import from MS Fabric? A: You can import data from Lakehouses, Data Warehouses, KQL Databases, and other Fabric items.

Q: How often can I schedule data pulls from MS Fabric? A: You can schedule data pulls daily, weekly, or monthly.

7. Support & Additional Resources