Power BI and Dynamics 365 in project and sales work
Yuliia Kamkova showed Frode Stenstrøm how Power BI can pull data from Dynamics 365 Project Operations and be embedded back into CRM.
Yuliia Kamkova showed Frode Stenstrøm how Power BI can pull data from Dynamics 365 Project Operations and be embedded back into CRM.
In this 2025 webinar, Yuliia Kamkova of ProsessPilotene showed Frode Stenstrøm how to pull project data from Dynamics 365 Project Operations into Power BI reports, with the goal of feeding that insight back into the CRM where project managers and salespeople already work. The starting point was that Project Operations only shows progress for one project at a time, with no view across a whole portfolio.
Kamkova pulled data from four Dataverse tables, project, project task, account and user, directly into Power BI Desktop via a SQL endpoint, and showed how the Level Up for Dynamics browser extension can reveal the logical field names needed in the queries. She then built a cross-project Gantt chart using a Power BI-certified custom visual, and explained why it pays to choose actively maintained, documented visuals over randomly downloaded code.
The report was then published to the Power BI service and added as a dashboard inside the Dynamics app via Power Apps, so it appears as a tab directly on the project page. Kamkova went on to a more advanced example where the report is automatically filtered by the customer's account ID, editing the form's XML with the XRM Toolbox tool so that each customer or contact only sees the projects that concern them.
The walkthrough gave a concrete example of how Power BI can combine data from multiple sources and deliver visualisations not available in the CRM's standard functionality, and noted that the same approach works with data from other systems, such as finance or inventory, without costly integrations.
CRM-Konsulent
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.
Ask a question or share what helped you.
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.
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.
Automation | Article
New tools for managing agent costs
Copilot administrators gained central controls for consumption-based cost. Purview controls extended to Cowork, and agent metrics could connect with organisational context.
Project management | Article
AI tools gained access to live project data
Federated connectors could retrieve live SaaS data through MCP. Copilot Notebooks gathered project context while Word and Teams gained collaboration features.
Copilot Notebooks and Cowork gained more ways to share project context. Agent metrics and cost controls expanded in the admin centre.
Microsoft published April news for manufacturing, Power Platform, Planner and Power BI. Together, the releases show how automation and analytics can support field work when project accountability, data quality and human control are clear.
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.
Control projects through forecasts, risks and changes
CourseIdentify deviations early and give customers decision material before time and budget are exhausted.
From sold engagement to an achievable project plan
CourseTranslate customer commitments into deliverables, ownership and acceptance in Project Operations.
June 2, 2026 • Konferanse — DynUG brought the Dynamics 365, Power Platform and Fabric communities together in Oslo.
Moelven's experience with leadership development
October 13, 2024 • Webinar — Terje Melheim and Ida Langdalen Kristiansen from Moelven told Frode Stenstrøm about active leadership and internal communication at the group.
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 6, 2024 • Webinar — Tor, Stian Lundquist from Microsoft and Jørgen from ProsessPilotene showed how customer data enables tailored campaigns.
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.
Solution
Project and Resource Management
Good project management improves the quality of your deliverables
Share a question or reflection.
Be the first to contribute.
