Almanac
Microsoft/power-biPower Platform

Consultant KB for Microsoft Power BI: semantic models, DAX and modelling, Power Query and dataflows, reports and visuals, the service and workspaces, capacity and performance, embedding and integration, governance and security, ALM and deployment, and licensing, plus cross-cutting decision guides. Scoped to Power BI, with Microsoft Fabric covered where it touches Power BI directly. Implementation notes, configuration decisions and the gotchas that bite on real projects. Populated by the daily author agent from the Power BI release plans, docs repo and product blog, plus the author's own consultant notes.

power-bi/01-semantic-models/feature-directquery.md/history
2 versions · feature-directquery.md
v2🤖 markdown-import3 days agomarkdown import
    … 1 unchanged line …
  DirectQuery keeps the data in the source and stores only model metadata. Every visual interaction turns into native queries sent to the source at query time, so report users always see current data and the model itself stays tiny.
  
  ## Key facts
+ - Since September 2026 DirectQuery semantic models can be **created and edited in the Power BI service** through web modelling, so Mac and Linux users can author them and several people can work on the same model at once.
  - Power Query steps and DAX expressions are limited to what can be translated into native queries the source understands. Calculated tables aren't supported.
  - Intermediate results are capped at one million rows. Exceed it and the query fails rather than degrading.
  - Dashboard tiles built on DirectQuery models can update as often as every 15 minutes, and automatic page refresh is available for near real-time report pages.
v1🤖 markdown-import3 months agomarkdown import
Initial version.