Excel-PowerBIYour weekly briefing from the Excel & Power BI world
Independent · free · no spam

Your weekly briefing from the Excel & Power BI world.

Releases, community questions, videos, projects, events and certifications — pulled, deduped and ranked from across the Microsoft data ecosystem, so you don't have to babysit twenty tabs.

Illustration of a weekly analytics briefing dashboard
Live example

This week's issue

A live example of what lands in your reader every Tuesday.

📣 News & announcements

01

August Power BI Desktop feature summary is live

New DAX window-function options, on-object formatting improvements and Copilot updates ship in the August build.

News · Power BI Blog
02

Fabric adds more Direct Lake surface area

Direct Lake now covers additional connectors and a smoother fallback path to DirectQuery.

News · Microsoft Fabric Blog

🧩 Release notes

01

Power Query: query-folding indicators improved

'View Native Query' now surfaces on more transformation steps.

Release · Power Query Blog
02

Office Scripts: scheduled triggers via Power Automate

Run a script on a recurring schedule without opening the workbook.

Release · Microsoft Learn

💬 Community Q&A

01

How do OFFSET and WINDOW differ for running totals?

Top-voted answer walks through partitioning and ABS/REL framing with a worked measure.

Q&A · Stack Overflow · [dax]
02

Direct Lake model keeps falling back to DirectQuery

Community thread pins the cause to unsupported data types and SKU guardrails.

Q&A · r/PowerBI

🎬 Videos, summarized

01

Direct Lake explained in 12 minutes

Guy in a Cube breaks down when Direct Lake beats import and where it falls back.

Video · Guy in a Cube
02

Window functions: the end of self-joins in DAX

SQLBI demonstrates INDEX/OFFSET/WINDOW with period-over-period examples.

Video · SQLBI

🛠️ Projects & tools

01

DAX Studio 3.x: faster query plans view

New build improves server-timings capture and export.

Tool · DAX Studio
02

Measure Killer: unused-measure cleanup

Scan a model for unused measures and columns before shipping.

Tool · Measure Killer

🎓 Events & certs

01

DP-600 (Fabric Analytics Engineer) study path refreshed

Microsoft Learn updates the skills-measured outline ahead of the next window.

Cert · Microsoft Learn
02

Power BI user groups — this month's meetups

Regional groups post agendas and recordings.

Event · Fabric Community
Read issue
New · quick tests

Test your Excel & Power BI skills

Bite-sized quizzes by topic and difficulty — or full interview-prep sets by role (Power BI Developer, PL-300, DP-600). Trickier options, and a fresh draw from a large pool every time.

DAX L1–L3ExcelPower QueryFabricInterview prep
Which function sums an expression row by row over a table?
SUM
SUMX
CALCULATE
One briefing, everything that moved

Stop monitoring ten channels. Read one.

News
📣

News & announcements

Product news from the Power BI, Excel, Fabric and Microsoft 365 blogs — summarized, not just linked.

Releases
🧩

Release notes

Monthly Power BI Desktop updates, Excel Insider builds, Power Query, DAX, Office Scripts & Fabric — version-bumped and explained.

Q&A
💬

Community Q&A

The questions worth reading from Stack Overflow, r/PowerBI, r/excel, the Fabric Community and MrExcel.

Video
🎬

Videos, summarized

New uploads from Guy in a Cube, SQLBI, Leila Gharani, ExcelIsFun, Curbal & more — summarized from transcript.

Tools
🛠️

Projects & tools

Trending repos — Tabular Editor, DAX Studio, Bravo, Measure Killer, EPPlus, xlwings — and fresh templates.

Certs
🎓

Events & certs

FabCon, Power BI Summit, user groups and exam tracks — PL-300, DP-600, DP-700 — with dates and deadlines.

Live
📈

Pulse

A live view of what the Excel & Power BI community is talking about this week — trending topics.

Track
🗺️

Roadmap

Track features across the Microsoft 365 & Fabric release plans — announced, in preview, GA or deprecated.

AI
🤖

Ask in plain English

An assistant that searches every source and answers in your role's context — with citations.

How it works

Pulled, deduped, ranked — then delivered.

From 40+ sources, deduped and ranked into one weekly briefing
1

We watch the ecosystem

40+ public sources — official blogs, GitHub, YouTube, forums, release plans and exam catalogs — checked continuously.

2

We cut the noise

Duplicate stories merge, low-signal chatter drops, and what's left is summarized and ranked by relevance to your work.

3

You choose the format

Read it on the web, or wire the MCP server straight into Claude, Cursor or Copilot.

Topics

Landing pages for everything you build with.

Follow a topic to get only what's relevant — every release, question, video and project.

Explore topics
Pricing

Free. That's the whole pricing page.

$0
forever · no account required to read
  • The full weekly briefing on the web
  • Every section — news, releases, videos, projects
  • Pulse, Roadmap & all Topic pages
  • The AI assistant with cited answers
  • MCP server for Claude, Cursor & Copilot
  • No ads, no account required to read
Read the latest issue