Copilot in SharePoint August 2026: Live Dashboards

Introduction

Microsoft’s August 2026 update for Copilot in SharePoint focuses on making AI-generated experiences more useful inside everyday SharePoint workflows. For IT admins and site owners, the biggest change is that Copilot can now create interactive dashboards that stay connected to the source data instead of becoming outdated snapshots.

What’s new in Copilot in SharePoint

Live SharePoint dashboards from lists and files

Copilot can now generate an interactive HTML dashboard directly from a SharePoint list. It also supports Excel and CSV files as source data.

Key improvements include:

• Dashboards stay connected to the underlying list data
• Reports refresh when opened, reducing manual rebuilds
• Interactive filters and charts can be generated from natural language prompts
• New scenarios for project tracking, inventory, recruiting, approvals, and support escalations

This is a notable step for teams that currently export list data into separate reporting tools just to build executive views.

Launch Copilot prompts from a page button

SharePoint page authors can now connect a Button web part to a custom Copilot prompt. Users can click the button and run the prompt immediately without typing it manually.

Examples include:

• Drafting project status updates
• Generating executive reports
• Finding specific documents across a site
• Reviewing pipeline data assigned to the current user

This should help organizations surface approved, task-specific prompts directly where employees already work.

Chat and skills improvements

Microsoft also delivered several usability refinements to the Copilot chat experience:

• Type / in the prompt box to quickly add files, people, and meetings as context
• Improved built-in search for grounding prompts with relevant content
• Polished skill cards for smoother creation and invocation
• A more compact chat layout with improved citation hover cards

Why this matters for admins and site owners

The live dashboard capability could reduce the need for manual reporting processes built around SharePoint Lists. It also gives business users a simpler way to create lightweight, connected reporting experiences without leaving SharePoint.

Prompt buttons are equally important for adoption. Admins and site owners can guide users toward consistent, approved Copilot actions instead of relying on everyone to write effective prompts from scratch.

Next steps

• Identify SharePoint Lists that are currently exported for recurring reports
• Test live dashboard creation with a pilot team
• Add Button web parts to high-traffic pages for common Copilot tasks
• Review licensing, as Copilot in SharePoint requires a Microsoft 365 Copilot license
• Explore the Copilot in SharePoint Adoption Hub and Prompt Library for rollout guidance

These updates show Microsoft is pushing Copilot in SharePoint beyond chat and into practical site-based automation and reporting.