Posted inDynamics NAV & BC Tips & tricks

Using tables instead of table extensions

Recently James Crowter wrote an excellent article about table extensions and how they affect performance. In short, table extensions are great for flexibility and ease of development, but performance decreases when the number of table extensions is adding up. Especially when table extensions are used for…
Posted inData & Analysis

Table.Buffer() Does Not Buffer Nested Values

It’s actually really difficult to come up with a simple demo query to prove this though (the Power Query engine is too clever about not evaluating things it doesn’t need for the final output of a query), but it’s fairly easy to understand the principle. Whenever…