Episode 302 – Power BI August 2025: Edit Models in Service, Copilot in Embedded Reports & The Atlanta ER Adventure
Recording from Atlanta TechCon—where John experienced the American healthcare system firsthand via a midnight emergency room visit for deep vein thrombosis—Jason and John covered the Power BI August 2025 feature summary. Between hospital stories and demo fails, they unpacked major updates including full semantic model editing in the service, copilot support for embedded reports, and TABULAR view enhancements.
The Atlanta Adventure: From Stage to ER
John’s conference experience took an unexpected turn when his calf swelled “like a balloon.” After Jason’s mother handed the intervention baton to Jason, who then consulted John’s doctor son, the diagnosis came back: get to the emergency room immediately.
“You decided that you really need to experience it firsthand in order to be able to give proper color commentary over dinner,” Jason teased about John’s Canadian perspective on American healthcare.
Despite returning to the hotel at 2:30 AM, John appeared on stage the next morning for their tips and tricks session—featuring plenty of demo fails that became teaching moments about recovery. The duo filled their TechCon bingo card: emergency slide evacuations, fire alarms, tornado alerts, hailstorms, and now an ER visit.
“This will be fodder for a while,” Jason noted. “We’re waiting for a demo to load, I’ll tell this story.”
The round table session provided therapeutic group commiseration for a government employee struggling with Power BI challenges, running 70 minutes of “life, the universe and everything of Power BI.”
Copilot Reaches Embedded Reports
The headline copilot update: support for embedded reports in SharePoint Online—though testing revealed it extends beyond SharePoint to general website embedding.
When embedding via File > Embed Report > SharePoint Online, a new “Enable Copilot” checkbox appears with requirements documentation. The feature requires:
- Paid Fabric capacity (not trial)
- Appropriate licensing (Pro, PPU, or F64+ for visualization)
- Authentication tokens to verify access
John and Jason discovered the checkbox also appears in “Website or Portal” embedding (secure iframe embedding), despite the blog post restricting mention to SharePoint. They correctly predicted it wouldn’t appear for anonymous “Publish to Web” scenarios since copilot requires authentication.
Important distinction: the SharePoint list visualization feature (which auto-generates Power BI reports from lists) doesn’t support copilot—it remains locked in a hidden Pro capacity with unchangeable licensing requirements.
Full Semantic Model Editing Arrives in Service
The month’s biggest announcement—which the duo initially missed—completed the web editing story: Power Query editing for import models now works in the Power BI service.
“When were you able to do anything but DAX changes to a model in the service?” John questioned. The feature was announced in June with transparency about missing the deadline, then quietly shipped in July while they were at the Atlanta conference.
“Here’s the thing that you and I postulated for years… just be honest with us and be transparent that we’re missing a deadline,” Jason noted. “They did this and you know what happened, John? We freaking forgot that they had even said it.”
The feature completes the vision for browser-based development:
- Full Power Query editing for import models
- Improved error handling (no more restarting the entire window)
- Native query support added post-launch
- Workspace-level preview setting removed—now controlled only via admin portal
“How long have people asked us? ‘Do you have to use desktop?'” John reflected. “This completes the picture. You can fully edit everything about your semantic model.”
For Mac users seeking Power BI Desktop: “I wouldn’t keep holding my breath on that, ’cause why would you need to at the end of the day, if you can do it in the browser?”
Jason saw LinkedIn posts from Microsoft employees but assumed it was internal-only until discovering it live in their tenant that morning. They’ll incorporate it into future tutorials, with John planning to challenge himself using only the service for his SharePoint demo.
TABULAR View Gets Enhanced
Another feature they’d missed: TABULAR view now exists in the service, not just Desktop. The scripting interface for semantic models gained:
- Named expressions support
- Script object sections
- Ability to drag from Model Explorer directly into the code editor (respecting selections)
- No more manually selecting everything to script specific measures
John loves TABULAR view for its scripting capabilities—previously requiring manual selection, now respecting Model Explorer organization. He demonstrated using it with Cursor AI to generate measure descriptions in bulk.
Copilot Improvements & Documentation Importance
Additional copilot updates included:
- Measure descriptions GA: Copilot writes measure descriptions via a button under the description field
- Filtered report summaries: Standalone copilot now intelligently applies filters without opening reports first (preview)
- Previously you’d ask “what were 2024 sales?” and it would open an unfiltered report; now it applies relevant filters inline
Jason emphasized documentation vigilance: “You really have to look at what the documentation is saying… We’re building a laziness in us that we just expect that a copilot experience over here is gonna be the same as a copilot experience over here.”
Different copilot contexts have different capabilities—assumptions lead to wrong answers treated as authoritative. “RTFM. Read the manual.”
Org Apps Expand to Pro Workspaces
Support for org apps (not workspace apps—they’ll dedicate a future episode to explaining the distinction) reached preview in Pro workspaces. This raised semantic questions about whether org apps remain a “Fabric feature” if they work in Pro.
John’s take: “Power BI is a part of Fabric, isn’t it? But it lives on its own… If you’re just using Power BI Pro, you’re not using Fabric.”
The full apps explanation will come in a future episode, as the duo acknowledge getting “wrapped around the axle” on the distinctions between org apps, workspace apps, and store apps.
Databricks Integration & Refresh Templates
Additional modeling updates included:
- Mirrored Azure Databricks catalog support for Direct Lake in Power BI Desktop—expanding targets without requiring data physically in Fabric
- Semantic model refresh templates in Fabric pipelines (preview, rolling out through end of August)—replacing the nightmare of clicking 144 times to set up 48 daily refreshes
John celebrated the refresh template advancement: “For 10 years now… you couldn’t do this. If you’ve got a premium capacity and you want to refresh it more than eight times a day, you’re having to enter each one of those refresh times in the UI. Up to 48 times, three clicks to do that. That’s crazy.”
Pipelines enable:
- Refreshes at seven minutes after the hour (not just on-the-hour/half-hour)
- Event-driven triggering after dataflow completion
- Better source system load distribution
Data Connectivity & Typo Fun
The data connectivity section featured:
- Impala connector implementation 2.0 (preview) replacing existing ODBC driver
- “Entral authentication” for PostgreSQL—prompting Jason to poke fun at the typo despite reporting it a week prior
“I think this is us poking fun at a typo, which hopefully will get updated,” Jason noted, referencing what should read “Entra ID authentication.”
PBIP Simplification
Live connect reports saved as PBIP now use simplified connection strings containing only the XMLA endpoint and semantic model ID—removing extraneous information.
“Doesn’t everybody know what their PBI model virtual server name is?” John deadpanned, joking about his “tattoo on my back.”
Looking Ahead
With FabCon approaching, the August drop exceeded expectations. Jason noted Power BI returning “with thunder this month” after Fabric took center stage for extended periods.
The team plans future episodes on:
- Deep dive into org apps vs. workspace apps vs. store apps
- Practical applications of web-based model editing
- More from their Atlanta conference adventures (minus the ER visits)
Between the medical drama, demo fails that became teaching moments, and major feature drops that quietly shipped while they weren’t looking, August 2025 reminded everyone that staying current requires constant vigilance—and maybe checking your legs before conferences.
Links:
- Power BI August 2025 Feature Summary
- Fabric Roadmap
- Episode 300 – Domain Tags, Data Agents Meet Copilot Studio & Cosmos DB Arrives
Subscribe: SoundCloud | iTunes | Spotify | TuneIn | Amazon Music
