M365 Show Podcast

Copilot Extensibility for Microsoft 365 Developers


Listen Later

Ever tried asking Copilot about your company’s buried legacy data, only to get a generic answer back? You’re not alone. Copilot’s out-of-the-box knowledge stops at what Microsoft gives it—but what if you could change that? Today, I’ll show you how to plug your own data sources like internal wikis or ancient CRMs straight into Copilot using Microsoft Graph Connectors. By the end, you’ll know exactly how to make Copilot as smart about your business as your top analyst.Why Copilot Misses the Mark with Your DataIf you’ve ever asked Copilot for info about your company and watched it stumble, you’re not alone. Most of us want to believe Copilot sees everything important—customer conversations, legacy docs, even those ancient Excel sheets tucked away in an old file share. But the reality hits pretty quickly: Copilot only knows what’s inside a pretty narrow box, and your business probably lives well outside of it. For people using Microsoft 365 every day, that’s a real shock. You open up Copilot expecting it to work like a virtual brain for your business, but instead, it starts acting more like that new hire who hasn't figured out where the coffee machine is yet.Here’s a quick example that lands with almost every manager. Imagine you’re sitting down to prep for a quarterly review, and you ask Copilot, “What was our sales process last year?” Instead of pulling up actual steps or even hinting where to look, Copilot just throws its hands up—nothing. You might get a summary of some teams chats from last week, maybe a link to a marketing deck from January, or a vague statement about best practices, but nothing about the process your sales team actually used. The details you need are stuck in systems Copilot can’t even see—maybe an old CRM, or a private documentation site built by someone who left three years ago.The root problem comes down to this: Copilot’s default permissions only cover what’s already inside the Microsoft 365 ecosystem. Think Outlook, Teams, OneDrive, SharePoint—if it lives there, Copilot is pretty helpful. Beyond that? It’s like Copilot has a blindfold on. Your company’s custom ticketing platform, the finance department’s internal Wiki, or that CRM from 2012 with more duct tape than documentation—none of it makes the cut. And it’s not just obscure systems. Confidential docs, records that live in separate business lines, or anything stored in an app that wasn’t built for Microsoft 365 stays invisible to Copilot by default.This limitation isn’t just theoretical. The numbers back it up. According to several industry studies and Microsoft’s own reporting, as much as 80% of a typical organization’s data sits outside the standard Microsoft 365 sources. That means Copilot—if left alone—misses most of your company’s real knowledge. So, when you think about all the key processes, historic strategy docs, or customer notes living in other tools or file shares, it makes sense why Copilot sometimes feels less like a genius assistant and more like a well-meaning intern who just started Monday morning.That gap between what Copilot sees and what you actually need leads to a lot of wasted time. Instead of getting answers handed to you, teams end up pinging each other on Teams, scouring old SharePoint sites, or, if you’re lucky, finding someone who remembers where the old “how-to” lives. This kind of hunting isn’t just annoying—it’s a productivity drain. People can spend half an hour tracking down one answer Copilot should have found in ten seconds. Multiply that by dozens of searches a week, across a company’s worth of employees, and you’re suddenly looking at entire workdays lost to digital hide-and-seek.There’s another side to this that stings a bit. When Copilot can’t answer the kinds of questions you actually have, people start losing trust in it. IT rolls out Copilot across the org, touts it as game-changing, and then the first real-world query lands with a dull thud. You’ll hear things like, “It couldn’t even tell me where the onboarding checklist is from last year,” or “I asked about our old pricing model and got nothing.” Eventually, the hype wears off and the tool becomes just another app taking up space in your workflow.But here’s where the story changes: recognizing this limitation is actually useful. Most organizations don’t even realize Copilot can be extended—they assume what you see is what you get. But knowing that Copilot’s “eyes” stop at Microsoft 365 helps you take a step back and ask better questions. Do you want Copilot to actually help people with real business processes—not just rewrite emails or summarize chats? Then you need a way to open up more of your data to it, without handing over the keys to the entire kingdom.Even if you’re skeptical, consider what it would mean if all those internal wikis, old CRMs, or legacy support ticket systems were suddenly searchable from Copilot. No more bouncing between systems, asking around, or hoping the person who created that doc is still at the company. Just quick, reliable answers from a tool that knows your business, not just generic Microsoft tasks. And for admins and architects, this opens a bigger conversation: if most of your knowledge is locked away, wouldn’t freeing it up be the first real step in making Copilot actually deliver on its promise?So now the obvious question: what does it actually take to bridge that gap between what Copilot knows and what your business really needs?Three Ways to Make Copilot Smarter—And Why Graph Connectors Stand OutLet’s get honest for a second: most folks hear about Copilot, see the demos, give it a spin, and think that’s all there is to it. But here’s the thing—they’re only scratching the surface. Microsoft quietly offers ways to crank Copilot’s skills way beyond the standard features, but only if you know where to look. Underneath the glossy headlines, there are three main ways to crack open Copilot’s potential: Graph Connectors, plugins, and custom data sources. Each one sounds promising on paper, but how they work in the real world is a different story.So, let’s break down where each option fits—and where they definitely don’t. Plugins are getting a lot of attention right now. Think of them like attachments for Copilot: you plug in a tool, and suddenly Copilot learns one new trick. That might be connecting to a SaaS platform or running a specific workflow. It’s like putting a fancy air freshener in your car. Does it make the ride a bit nicer? Sure. But if you’re dealing with legacy databases or files written in a language only your ex-admin could read, plugins start to feel limited fast. The same goes for custom data through APIs. In theory, there’s no limit to what you can hook up. In practice, developers run into brick walls with unstructured data, unpredictable schemas, or systems that were architected in the era of floppy disks.This is where Graph Connectors show up and quietly outshine everything else. Picture them not as another bolt-on, but as sturdy bridges built right into Microsoft 365’s infrastructure. Instead of just teaching Copilot a single new skill, Graph Connectors actually widen Copilot’s field of vision. Where plugins are like adding gadgets, Graph Connectors are more like knocking down the walls so Copilot can finally see the entire room. And with most businesses, that room is cluttered with forgotten file shares, third-party wikis, ancient CRMs, and homegrown ticketing systems that refuse to retire.Let’s put this in perspective with some quick analogies. Plugins? They’re the little add-ons you pick up at the checkout aisle—handy, but narrowly focused. Custom data sources? Picture building your own bespoke meal from scratch. It’s made exactly to your taste, but also more work to maintain and not always compatible with your kitchen’s appliances. Now, Graph Connectors—they’re more like bridges over a river. They connect the stuff you want, securely and in bulk, so traffic actually flows and Copilot gets real access to what’s valuable.Here’s where it gets interesting for the kind of headaches most IT teams actually feel. Out of all the options, only Graph Connectors make it easy for Copilot to index, comprehend, and surface data from places it was never intended to look. That internal wiki everyone forgot, the CRM from two mergers ago, a file share that’s half-accessible because nobody remembers who owns it—suddenly, Copilot can pull structured knowledge from all of them and serve it up inside its familiar chat or search. This isn’t theoretical, either. We worked with an admin who set up a Graph Connector for their internal documentation portal, which had been running on an unsupported CMS since 2015. Within a day, Copilot could answer detailed technical questions, reference archived policies, and help users who’d never even seen the original wiki. Before the connector, only the original authors stood a chance of finding anything useful. Afterward, it was as if that knowledge base had become part of Copilot’s native skill set.Graph Connectors also nail something the other two options tend to overlook—security and scalability. They honor the same permissions already baked into your Microsoft 365 environment, so you don’t have to reinvent your access model. If a user can’t see a document in the old system, they won’t see it via Copilot either. Plus, you’re not stuck rearchitecting how data flows between apps, or writing custom code to keep weird formats readable. The connector brings external data into the Microsoft Graph index, making it searchable and actionable without breaking the rest of your security posture.So, when does it make sense to pick one tool over another? Plugins are best when you need a specific integration—like plugging into a critical service with a defined API, but not much else. Custom data routes work if you have highly specialized needs and the time to build your own connection logic. But when you want broad, reliable, and ongoing access to big swaths of business data—espe

Become a supporter of this podcast: https://www.spreaker.com/podcast/m365-show-podcast--6704921/support.
...more
View all episodesView all episodes
Download on the App Store

M365 Show PodcastBy Mirko