Microsoft 365

Overview

Integrate Microsoft 365 data sources including Excel workbooks, SharePoint lists, and Teams activity into unified dashboards. Visualize data stored across your Microsoft ecosystem without manual consolidation. Ideal for enterprises standardized on Microsoft tools needing centralized reporting.

How it works

Authenticate with Microsoft 365 and grant Lumis access to Excel, SharePoint, and Teams. Select workbooks and lists to visualize, and Lumis automatically generates appropriate charts based on your data structure. Real-time sync keeps dashboards current as team members update files.

Configure - implementation details

Microsoft Graph API provides unified access across 365 services. Delta queries efficiently sync only changed data, minimizing API calls.

// Microsoft Graph data sync
const client = Client.init({authProvider});

async function syncExcelWorkbook(driveId, itemId) {
  const workbook = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook`)
    .get();
    
  const tables = await client
    .api(`/drives/${driveId}/items/${itemId}/workbook/tables`)
    .get();
    
  return tables.value.map(t => t.rows);
}

Connect Excel, SharePoint, and Teams data to create unified dashboards across your Microsoft 365 workspace.

Configure - implementation details

Ready to power your venture?