Insights / Digests

Digest

AI for BI: week of October 31, 2026

A Windows update breaks the Power BI modeling connector, Microsoft 365 Copilot's Power BI link is released, and SQLBI's DAX benchmark.

Upside Analytics R&D1 min read

This week: a Windows update hides open Power BI Desktop files from the modeling connector, Microsoft 365 Copilot becomes the official place to chat with Power BI data, and SQLBI's bigger test shows the best AI models now write correct DAX over 90% of the time.

Act on it

  • A Windows update (KB5127936) stops the Power BI modeling connector from finding an open Power BI Desktop file. At least four people report it. If Claude cannot see your open model after a Windows update, this is why. Asking the AI to look up the model's port number by itself works around it. GitHub issue
  • Microsoft 365 Copilot's link to Power BI models is officially released, and Chris Webb says it is where teams should start. Users ask data questions in the Microsoft 365 Copilot app, and your existing synonyms and AI instructions still apply. Expect questions about it before data agents. Chris Webb

Worth knowing

  • The best AI models now score over 90% on SQLBI's bigger DAX test. Tasks include DAX optimization and user-defined functions, and each runs once with no retries. Use it to pick a model. SQLBI video
  • An AI agent can rewrite slow DAX, test it and benchmark it, SQLBI shows, but people still found the better rewrites, and no single version was fastest in every report layout. Keep your own performance testing. SQLBI video
  • Test your AI instruction files like code. Tabular Editor suggests comparing answers with and without the file: if it adds nothing, it only clutters the AI's context, so cut it. Useful if you write Claude skills. Tabular Editor

New in Power BI

  • A built-in Gantt chart visual is in preview. It handles tasks, milestones and progress; it has no "today" line and no task dependencies yet. Handy for project-plan reports. Video tutorial

Want to talk about this?

We build governed reporting and AI for BI for financial services teams.

[email protected]