Every Monday morning, somewhere in a Latin American company, someone is rebuilding a dashboard.
Not because the data changed unexpectedly. Not because the system broke. But because that's how it works: you export the SharePoint list, paste it into Excel, build the visual, share the file, and three days later the list has been updated and the report is lying. The cycle starts over. It always starts over.
Microsoft delivered in August 2026, inside Copilot for SharePoint, a feature that breaks that cycle: interactive HTML dashboards generated from lists, which stay connected to the source and refresh automatically every time they're opened.
The cycle every intranet manager knows by heart
The situation is so common it became invisible routine. You have a SharePoint list with projects, tickets, purchase orders, inventory. Someone, at some point, decided that needed "a prettier presentation" and built a dashboard. In Excel. Or on a separate site that someone forgot to update.
The problem isn't the tool. The problem is that the data lives in one place and the visual lives somewhere else. When the list changes, the report doesn't know.
| Before | Now | |
|---|---|---|
| Data source | Manually exported list | List connected at open time |
| Who builds the visual | Analyst or technical owner | Any user with a Copilot license |
| Creation time | Hours (Excel, Power BI, formatting) | ~5 minutes via prompt |
| Updates | Manual, when someone remembers | Automatic on open; Refresh button if already open |
| License to view | Depends on the tool (Power BI Pro, etc.) | None beyond list access |
| Permissions | Managed separately in the report | Inherited directly from the source list |
| Multiple lists | Manual join in Excel or Power Query | Referenced in the prompt, including lookups |
| Where it lives | Loose file, email, shared folder | HTML in SharePoint, embeddable on any page |
The list never lied. It was the dashboard that fell behind.
Who creates it, where it lives, and how it works
To generate the dashboard, the user needs a Microsoft 365 Copilot license. No technical skills, no Power BI knowledge, no code. The process starts inside the list itself: click the Copilot button on the right side of the screen, describe what you want to see, and in about five minutes the file is ready.
The result is an HTML file saved automatically to Site Assets or the site's Documents library. From there, two options: share the direct link, or embed the file on any SharePoint page using the Embed web part.
The people viewing the dashboard don't need a Copilot license at all. They only need access to the source list. That's the central point of how permissions work: the dashboard has no security of its own. It inherits exactly the same controls as the list. If someone doesn't have list access, they won't see data in the dashboard. The HTML file exists, but it loads blank.
One list? Multiple lists. And lookup columns too
A fair question: does the dashboard only work with one list at a time?
No. The prompt can reference multiple lists in the same request, including relationships between them. If the projects list has a lookup column pointing to a departments list, that can be included in the prompt as a "parent/child relationship" and Copilot generates the visual considering those connections.
The same applies to files: beyond SharePoint lists, Copilot accepts Excel files and CSVs as sources. If the data lives in a spreadsheet and hasn't been migrated to a list yet, the feature works just the same. The usual caveat applies: lists offer per-item version history, edit traceability, and granular permission control. If the data changes frequently and knowing who changed what matters, a list is the right place for it.
What the data refresh actually means in practice
When someone opens the dashboard for the first time, it loads the current data. If the dashboard was already open and the list was updated, just click Refresh to pull the latest state.
It's not real-time synchronization like a Power BI streaming dashboard. It's on-demand loading. For most corporate use cases, that's enough: the report you open in Monday's meeting shows what the list has at that moment, not what it had when someone generated a file last week.
And Power BI? Does it still have a place in all this?
Yes. But its place has shifted.
Power BI is still the right choice when data comes from multiple sources outside SharePoint, when updates need to be scheduled and automatic, when the report requires dimensional modeling, DAX measures, or row-level security. For those scenarios, the Copilot dashboard isn't a competitor. It's a different thing entirely.
What changes is the entry point. Before, any need to "visualize data from a list" became a Power BI project because there was no faster alternative. The result was heavy infrastructure for simple questions: how many projects are at risk, how much was spent per department this month, which tickets have been open more than seven days.
For those questions, the Copilot dashboard is enough. And "enough in five minutes" has a value that "perfect in two weeks" can rarely compete with.
The practical read: Power BI for strategic analysis, complex modeling, and data coming from outside Microsoft 365. Copilot dashboards for day-to-day operations, inside SharePoint, with data that already lives in lists. Both coexist, and that division of responsibility is more honest than either one trying to do the other's job.
The point
No technology solves the problem of someone who doesn't want to use the intranet. But for those who already use SharePoint lists and still spend time every week rebuilding reports from them, August 2026 was the month that work lost its justification.
The data lives in the list. The dashboard reads the list. The report reflects reality. And the people who need to see it don't need any extra license to do so.
Want to know what's changing in Microsoft 365 before it changes at your company? The Macareno newsletter arrives every week with exactly that.
Sources
- What's New in Copilot in SharePoint: August 2026 — Microsoft Tech Community
- Build a SharePoint Copilot Dashboard With a Single Prompt — IW Mentor (Laura Rogers)