// Blog

Data Modeling

Practical Power BI, DAX, Microsoft Fabric, Power Apps and Power Automate — the patterns we use on real client projects.

Power BIPower AppsDataverse

From Power Apps and Dataverse to Power BI: Turn a Business App into a Scorecard Dashboard

A practical Dataverse-to-Power BI pattern for modeling app records, targets, approvals, security, refreshes and useful Power Automate alerts.

Oct 21, 2026 · 7 min read Power BIExcelPower Query

How to Migrate Excel and Google Sheets Reports to Power BI: One Data Model, Scheduled Refresh and Numbers That Reconcile

Move manual Excel and Google Sheets reports to Power BI: map tabs to a star schema, combine files in Power Query, schedule refresh and prove totals match.

Oct 12, 2026 · 13 min read

Need this built for your team?

30 minutes. No sales pitch. Just an honest conversation about your data and how we'd approach it.

Book a discovery call Send a message