Courses, Blueprints, Briefings, Blockers, and Pulse — together in last-update order.
Collab365 Team
Power BI moves semantic-model refresh schedules, credentials and related options into a workspace side pane. Faster first diagnostics when reports go stale still require clear ownership and verified credentials for production models.
Collab365 Team
SharePoint folder connectors still fail scheduled Power BI and Excel refresh when paths, file names, gateways, or service-account permissions change. Docs restate the limits: unattended refresh needs frozen layout and credentials, unlike desktop open-and-load.
Collab365 Team
Power BI stops loading semantic models from the legacy Excel-import path on 31 August after refresh ended 31 July. Teams must find workbook-based reports, migrate to a supported semantic model or OneDrive/SharePoint path, and verify refresh plus dependent reports.
Collab365 Team
Fabric Custom SQL Pools isolate warehouse workloads and cap resource share per pool. Reporting can run slower for a smaller, more predictable allocation footprint. Teams should label interactive, refresh, ingestion and ad-hoc work before expanding pools.
Collab365 Team
Detail Rows Expressions define which rows sit behind a Power BI measure, but only Excel showed them. A paginated report visual on a drillthrough page surfaces that output for one measure at a time so totals match the modeller’s definition.
Collab365 Team
Microsoft’s August SharePoint update lets Copilot turn Lists, Excel, or CSV into interactive HTML dashboards that stay linked and refresh when opened. Teams can pilot a live operational view instead of static exports while still validating source quality, permissions, and…
Collab365 Team
Excel Copilot can draft multi-criteria report formulas with XLOOKUP, FILTER and SUMIFS on Tables. Report builders still need to state the job—one record, all matches, or a total—and reconcile the formula against known cases before reuse.
Collab365 Team
A PowerShell pattern groups six weeks of Planner open-task snapshots from SharePoint by person, adds a six-week average, and shows whether each person’s open workload is falling over time.
Collab365 Team
Microsoft lists an active Fabric known issue where some embedded Power BI reports fail to render correctly in portrait mobile layouts. Desktop checks miss it; teams shipping embeds need real-phone portrait tests in release routines.
Collab365 Team
Power BI Dataflow Gen1 is labeled legacy but remains supported. Teams should inventory dependencies, then keep stable Gen1 flows, test Gen2 side-by-side, or plan controlled migration based on licensing, change needs, and Fabric access.
Collab365 Team
Microsoft Fabric stopped auto-creating default semantic models for lakehouses and warehouses. Import-based Power BI reports are largely unaffected. Owners of auto-generated models should inventory dependents before rename or delete. Task Flows and Direct Lake remain optional,…
Collab365 Team
Fabric Notebooks fit coded, large-scale data prep, not routine Excel cleanup or Power BI model fixes. Start with the simplest supportable tool; adopt a notebook only when custom logic, volume, reuse or named engineering ownership is required.
Collab365 Team
Flow groups let one Power Automate process licence cover up to 25 solution-aware cloud flows. Reporting teams can pool moderate SharePoint, Lists and pack jobs under shared capacity while isolating heavy refresh flows on dedicated licences.
Collab365 Team
Microsoft retires the Fabric data-agent integration in Copilot in Power BI on 26 August 2026. Teams using it must identify dependent reports, assign owners, and move work to supported experiences before the date to avoid broken AI layers.
Collab365 Team
Legacy browser Excel and CSV imports into Power BI stop for new models after 31 May 2026. Existing semantic models face later risk unless rebuilt in Desktop with Get Data, republished, and rebound to keep refresh and ownership intact.
Collab365 Team
Microsoft documents Power Query SharePoint Folder and List connectors for Excel and Power BI. File combine depends on consistent layouts, permissions, and paths. Schema drift and auth breaks remain common refresh failure modes for library-based reports.
Collab365 Team
Business analysts receive weekly exports from multiple departments. When column names and structures differ each time, merging files into one report requires manual fixes. Existing automation breaks on every change, pushing deadlines and reducing time for actual analysis.
Collab365 Team
Power users refresh Excel files manually every Monday, export PDFs, and email reports to managers. No automation or version history exists, so recreating past versions takes time and process stops if the user is absent.
Coming next
Live 25th Aug 2026Collab365 Team
Power BI totals diverge from Excel for seven ordinary reasons: filters, refresh timing, Power Query steps, relationships, non-additive DAX, RLS, and manual Excel adjustments. Checking them in order yields a defensible explanation for stakeholders.
Live 25th Aug 2026Collab365 Team
Reporting leads lose trust in Power BI dashboards when totals diverge from Excel. Undocumented spreadsheet edits and missing reconciliation processes create gaps that require expensive specialists to diagnose.
Live 15th Sept 2026Collab365 Team
Excel-strong reporting owners face broken refresh, disputed KPIs, and manual cleanup across Power BI, Power Query, and Fabric. Matching the failure to the bottleneck—not the product menu—avoids wasted license spend. A Report Tool Decision Record clarifies ownership and next…
Live 15th Sept 2026Collab365 Team
Accidental BI owners maintain critical monthly reports in undocumented Excel files. Each new Microsoft tool announcement triggers more training spend without fixing fragile formulas and hidden steps. Reports stay broken because implicit logic is never extracted first.
