Category Archives: Microsoft

Deployment pipelines are most valuable when they make a release routine. The goal is not to move a Power BI or Fabric item from one workspace to another with the fewest clicks; it is to make change traceable, testable, explainable, and reversible. That lifecycle perspective fits the deployment and governance skills around PL-300, but it […]

A scheduled refresh looks simple from the Power BI service: a semantic model has credentials, a schedule, and a refresh button. When an on-premises source is involved, however, the request crosses identity, cloud configuration, the gateway service, local networking, drivers, and the source system before a single row can be returned. Understanding that dependency chain […]

Power BI report design is often discussed as a matter of chart choice and color. In production, the harder problem is information architecture: deciding what a page is for, what decision it supports, how much evidence a reader needs, and how the report behaves when data is incomplete, slow, or viewed on a different device. […]

Semantic-model tuning is easy to turn into folklore: remove columns, rewrite measures, add aggregations, change storage mode, reduce visuals, and hope the report becomes faster. A stronger approach starts with evidence. The relevant question for PL-300 and for production teams is not which tuning technique is popular, but which component is actually responsible for user-visible […]

Incremental refresh is often introduced as a way to avoid reloading an entire Power BI table. That is true, but incomplete. The more useful mental model is that Power BI is managing time-based partitions whose boundaries are driven by policy, parameters, and the current refresh date. The operational challenge is therefore state: deciding which historical […]

Choosing between Import and DirectQuery is not a preference about freshness versus speed. It is an architecture decision about where query work happens, which system carries the load, how much latency users can tolerate, and how much operational dependence the reporting layer should place on the source. Those trade-offs sit directly inside the modeling decisions […]

Row-level security in Power BI is often introduced as a DAX rule attached to a role. The real security boundary is larger. The rule depends on identity, workspace permissions, model relationships, data-access mode, role membership, and the assumption that every filter path reaches the rows that should be protected. A rule can be syntactically correct […]

Time intelligence becomes difficult when the business calendar stops looking like a textbook calendar. Fiscal years can start in different months, weeks can follow a 4-4-5 pattern, retail periods can contain 53 weeks, holidays can move, and operational cutoffs can make “day” mean something other than midnight to midnight. A correct DAX function cannot rescue […]

Calculated columns and measures can both be written in DAX, which makes them look like interchangeable ways to express a calculation. They are not. A calculated column is evaluated for each row during refresh and its result is stored in the model. A measure is evaluated on demand under the current filter context. That difference […]

Power BI relationships do more than connect columns. They define how filters move through the semantic model, which makes them part of every measure and every security rule that depends on propagation. A model can contain valid keys and still behave unpredictably if there are multiple possible filter paths, unnecessary bidirectional relationships, or role-playing dimensions […]

Row context answers a deceptively simple question: which row is the expression looking at right now? Calculated columns naturally evaluate once for each row, and iterator functions such as SUMX create a row context over the table they iterate. Trouble begins when a developer expects that current row to behave like a report filter. It […]

A DAX measure is not a stored answer. It is an expression evaluated under a set of filters that changes with the report cell, slicer, visual axis, relationship path, and filters introduced by the formula itself. That set is filter context. Many DAX problems that look like syntax problems are actually context problems: the formula […]

Power Query transformations are displayed as a tidy list of steps, but the engine does not necessarily execute them one by one on the local machine. When a connector and transformation support it, Power Query can translate work into the source system’s native query language and let the source perform filtering, projection, aggregation, or joins. […]

A Power BI model can look clean in Model view and still be difficult to operate. The real test comes when business logic changes, a new fact source arrives, measures become more complex, and report authors start combining fields in ways the original developer did not anticipate. Star-schema design earns its value because it makes […]

CI/CD in Microsoft Fabric is easy to reduce to two features: connect a workspace to Git and use deployment pipelines to move items between environments. That description is accurate but incomplete. Production safety depends on the boundary between source-controlled definitions, workspace state, environment-specific configuration, data, credentials, and the operational checks that happen after deployment. A […]