Connecting business data with Microsoft Copilot
Frode Stenstrøm and Oscar Høvik gave an overview of how businesses can connect their own data to Microsoft Copilot.
Frode Stenstrøm and Oscar Høvik gave an overview of how businesses can connect their own data to Microsoft Copilot.
Frode Stenstrøm and Oscar Høvik from ProsessPilotene gave an overview of how businesses can connect their own business data to Microsoft Copilot. They described three levels: standard Copilots that Microsoft delivers ready-made (over 100 variants), extended Copilots where custom data is connected via plugins or connectors, and custom-built Copilots created in Copilot Studio or Azure AI Studio.
They explained key concepts for controlling a Copilot's behaviour: temperature (how predictable the answers are), tokens (how much text can be processed) and grounding (how answers are tied to sources and citations). These were used as criteria for choosing the right strategy based on the use case, development effort and where the data sources are located.
A central theme was the difference between Microsoft Graph connectors, which copy data into Microsoft's domain, and Copilot plugins, which perform real-time lookups against the source and can write data back. The choice affects security, compliance, and whether queries leave the company's own systems.
The recommendation was to use standard Copilots where they meet the need, extend with connectors or plugins when more customisation is needed, and only build custom Copilots when necessary. The recording is from January 2024 and reflects Microsoft's product landscape at that time, which has since developed further.
Gründer og teknologistrateg
Som gründer og teknologistrateg i ProsessPilotene jobber jeg med å hjelpe virksomheter forstå og bruke teknologi som en strategisk kraft for bedre arbeidsprosesser, kundeopplevelser og beslutninger. Rollen kombinerer forretningsutvikling, teknologirådgivning, virksomhetsarkitektur og formidling. Jeg arbeider særlig i skjæringspunktet mellom AI, CRM, digitale plattformer, data, analyse og fremtidens arbeidsliv. En sentral del av rollen er å være brobygger mellom ledelse, fagmiljøer og teknologi. Det handler om å gjøre komplekse teknologiske muligheter forståelige, vurdere hva som faktisk skaper verdi, og bidra til at digitale løsninger blir en naturlig del av hvordan virksomheter jobber. Jeg bruker også rollen til å formidle faktabaserte perspektiver på hvordan AI og teknologi påvirker ledelse, organisasjoner, ansatte og kunder.
CRM-Konsulent
Ask a question or share what helped you.
Turn Power BI findings into better decision meetings
CourseUse reports to prioritise action, assign ownership and assess whether interventions work.
Design Power BI reports that make the next step clear
CourseBuild clear, accessible reports around the user's decision and workflow.
Make Copilot a useful part of customer work
CourseDesign and test a role-based AI workflow with clear sources, checks and accountability.
Use Copilot in Excel for analysis you can verify
CourseAsk precise data questions, check calculations and turn findings into decisions with visible qualifications.
Jets Group's experience with AI in sales and order work
October 21, 2025 • Webinar — Trond Jarnes of Jets Vacuum told Stine Sletvold and Frode Stenstrøm how AI in Dynamics 365 Sales now automates quote lines.
AI agents: use cases and implementation choices
May 16, 2025 • Webinar — Adrian Sjøholt and Frode Stenstrøm of ProsessPilotene covered trends, models and use cases for AI agents in business.
June 19, 2025 • Webinar — Frode Stenstrøm and Adrian Sjøholt tested Google, OpenAI and Anthropic AI models on real project-planning tasks, from requirements to a presentation.
May 25, 2025 • Webinar — Frode Stenstrøm and Adrian Sjøholt had Google Gemini, Microsoft Copilot and Claude compete at drafting a contract.
Marketing | Customer story
Kristiania has digitised 16,000 student journeys – from recruitment and application to student life and alumni – in a customised CRM system that lets the school collaborate across former silos, driven by data.
BUA lends out sports and outdoor equipment through local branches and has experienced significant growth. They have therefore explored opportunities to create a system that ensures continued operations as they develop further.
Automation | Article
The data agent gained a larger role in analytics
OpenAI’s Data agent could investigate company data and build shareable interactive dashboards. Access controls and source trails needed to follow analysis and action through the workflow.
Customer Service | Article
Service Agent gained tools for staffing decisions
WEM MCP tools enabled time-off requests, shift swaps and shift bids in Service Agent. Administrators could enable each tool for a role, team or pilot group.
Automation | Article
Copilot gained more context from Power BI
Power BI reports and semantic models became grounding in Copilot Chat and Cowork. Shared chats, synced notebooks and Planner status connected analysis with collaboration.
Information security | Article
Norway to reconsult on its AI law after EU rule changes
On 4 August 2026, the Norwegian government announced that its proposed AI Act would return to consultation after changes in the EU simplification package.
Copilot Notebooks and Cowork gained more ways to share project context. Agent metrics and cost controls expanded in the admin centre.
The EDPB published new guidelines on web scraping for generative AI and adopted final blockchain guidelines.
Share a question or reflection.
Be the first to contribute.
