r/PowerBI • u/Jaapuchkeaa • 16h ago
Discussion Made fully functioning CRM inside Power BI with database write-back.
Enable HLS to view with audio, or disable this notification
AI Summary -
This CRM runs entirely inside a Power BI report:
→ Drag a deal across a Kanban board, and its stage is saved to SQL Server
→ Click "+ New deal," and a form opens over the page, like a real app
→ Convert a lead into an organization, contact, and deal in one click
→ Log calls, notes, and tasks, with overdue tasks flagged in red
The whole model runs on DirectQuery, so every KPI and chart reflects the change on the next click.
How it works:
• A custom Power BI visual I built in TypeScript (Kanban, forms, activity log)
• A small Python API that validates every write
• SQL Server with constraints and a full stage history
The data model follows Frappe CRM
It's a single-user proof of concept for now. For production use, we have to use Azure SQL, an HTTPS API, and Microsoft Entra sign-in so it runs in the Power BI Service.
My doubts now
1- Is it worth to make CRM /Management tools in Power BI with API functions for write-back, or better to use a proper full-stack application?
2- How can this be useful in Production env especially after Fabric apps? Is it better to use that instead of this?
3- Can this now be considered a Power Automate replacement???
