Fresh shifts, product changes, and external signals that may become tomorrow's blocker.
Collab365 Team
Excel University combines CUBESET, CUBESETCOUNT, BYROW, LAMBDA and CUBEVALUE to spill a dynamic bill-of-materials list from the data model. The range updates when the assembly code changes, without VBA. Suited when data lives only in Power Pivot and FILTER cannot reach it.
Collab365 Team
Power BI Desktop builds from March 2026 or earlier stop saving and sharing .pbix files to OneDrive and SharePoint from October. Teams still running old Desktop on analyst machines risk failed handovers; inventory versions and test the usual route early.
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
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
Microsoft stopped selling Power BI Premium P SKUs and directs customers to Fabric F SKUs when agreements end. After expiry comes a 30-day grace period, throttling from day 31, and rejected operations from day 91 without migration. Pro and PPU stay unaffected.
Collab365 Team
Semantic models built via Power BI’s retired Create-page Excel and CSV import stopped refreshing on 31 July 2026 and stop loading on 31 August unless recreated with a supported method. Reports can still open while serving unnoticed stale data.
Collab365 Team
Classic SharePoint Alerts end in July 2026 with no extension path. Inventory alerts on lists that feed Excel, Power Query, or Power BI reports and replace critical ones with Power Automate flows or SharePoint Rules.
