Notes from the Power Platform trenches

Power BIDAXPerformance

The Power BI Health Check: How to Audit an Existing Report

Audit an existing Power BI report with checks for number accuracy, DAX measures, Power Query, model performance, RLS, and sharing.

Oct 22, 2026 · 4 min read 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 Microsoft FabricDataflow Gen2Power Query

How to Troubleshoot Dataflow Gen2 Refresh Failures with Detailed Logs

Use Dataflow Gen2 detailed refresh logs to find failures and bottlenecks, rebuild what happened in a run, and share diagnostics safely.

Oct 20, 2026 · 2 min read Power BIDAXPower Query

Fixing a Power BI Dashboard After the Data Source Changes

Power BI showing wrong numbers after an Excel or SharePoint source change? Check Power Query, relationships and DAX, then validate the release.

Oct 20, 2026 · 6 min read Power BIDAXReport Maintenance

Taking Over a Power BI Report Someone Else Built: The Handover Checklist That Keeps the Numbers Right

A practical Power BI handover checklist for tracing sources, refresh, relationships and DAX, validating results, and planning the first 30 days.

Oct 19, 2026 · 6 min read Microsoft FabricEventstreamReal-Time Intelligence

New Eventstream Connectors in Microsoft Fabric: Cribl, Solace and SAP Datasphere

Fabric Eventstream now connects to Cribl, Solace PubSub+ and SAP Datasphere. Use cases, architecture and what to check before going to production.

Oct 19, 2026 · 2 min read Power BIBudgetForecast

Building a Power BI Budget vs. Actual Forecast with EAC

A practical guide to modeling budget and actuals at different grains, forecasting the finish, and tracking estimate at completion and burn rate in Power BI.

Oct 18, 2026 · 4 min read Power BIDAXPayroll

Adding Payroll and Headcount Measures to an Existing Power BI Model

A practical workflow for extending a finished Power BI model with payroll and workforce measures, from model inspection and filter context to source validation.

Oct 17, 2026 · 5 min read Power BIERPCRM

Connecting Power BI to Your ERP or CRM: Native Connector, API or Dataflow

Wiring Business Central, Salesforce, Zoho, Snowflake or ServiceTitan into Power BI — native connector, REST API, custom connector or dataflow, step by step.

Oct 16, 2026 · 9 min read Power BIMicrosoft FabricGantt chart

Power BI October 2026 Update: Native Gantt, Dropdown Slicer and What Else Is Actually Worth Turning On

A walkthrough of the Power BI October 2026 update — Gantt chart and dropdown slicer in preview, plus what you should enable and test before November.

Oct 16, 2026 · 5 min read Power BIMicrosoft FabricFabric IQ

Fabric IQ and Agentic Authoring Are Now GA: What It Means for Your Power BI Semantic Model

Fabric IQ is now GA in Microsoft 365 Copilot, grounding answers in your governed Power BI semantic models. What it changes and how to get the model ready.

Oct 15, 2026 · 5 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 Power BIDAXPerformance

Why Your Power BI Report Is Slow (and How to Fix It, Step by Step)

A practical diagnosis workflow for slow Power BI reports — Performance Analyzer, DAX measure fixes, cardinality, aggregations and star schema.

Oct 03, 2026 · 6 min read Power BICRMAzure Data Factory

Connecting CRM Data (HighLevel, Zoho, Salesforce) to Power BI: Power Query, REST API, or Azure Data Factory

Three ways to get CRM data like HighLevel, Zoho or Salesforce into Power BI — native connector, REST API, or Azure Data Factory — with the tradeoffs of each.

Oct 02, 2026 · 4 min read Power BIPower AutomateSharePoint

Building a Multi-Project Tracking Dashboard in Power BI with SharePoint and Power Automate

How to turn a SharePoint project list into a self-updating Power BI dashboard, with Power Automate keeping status, progress and deadlines current without manual refresh.

Oct 01, 2026 · 5 min read Power BIPower QueryData Warehouse

Stop Building One Report Per Data Source — Bring Everything Into One Power BI Model First

How to combine ERP, e-commerce and marketplace data into a single star schema with Power Query and Dataflows instead of shipping fragmented Power BI reports per source.

Sep 30, 2026 · 4 min read Power BIPower AutomateAutomation

Connecting Power Automate to Power BI to Keep Dashboards Fed Automatically

Three real ways to use Power Automate so your Power BI dashboard updates itself when new data shows up, with triggers, refresh calls and a Power Query pattern.

Sep 29, 2026 · 4 min read Power BIDAXFinance

How to Build a Profit & Loss Statement in Power BI (with Subtotals That Actually Work)

A step-by-step pattern for a real P&L in Power BI: a layout table, one DAX measure for accounts and subtotals, margin % rows and clean formatting.

Sep 28, 2026 · 5 min read