Table – Page 8 – Pardaan.com

Power BI Model Size Bloat And Auto Date/Time Tables

Opinion is split over Power BI’s ability to automatically create Date hierarchies in your model. Personally it drives me mad and I always turn it off, but I know a lot of people love the convenience of it. Whatever your feelings, though, it is important to…

23 December 2016

Dynamics NAV & BC Tips & tricks

Get Source Table from Page

Codeunit 700 Page Management is a Codeunit that I use once in a while. It has functions to get the Default Lookup Page or the Card Page of a certain table. It also contains functions to open a Page by only passing a Table ID or…

16 December 2016

Dynamics NAV & BC Tips & tricks

OnAfter table event subscriber patterns and antipatterns

The purpose of events is to simplify business logic customization while not impeding upgradeability and general extensibility. However, there is one particular class of events that may cause troubles: OnAfter* table events. There are four of them: OnAfterInsert, OnAfterModify, OnAfterDelete, and OnAfterRename. Bron : Vjeko.com Lees…

27 May 2016

Dynamics NAV & BC Tips & tricks

Design this Page/Table

As promised, here’s the source code for the Design this Page/Table prototype I posted the other day. As you can see, it’s really straight-forward; finding the database server name is probably the most complicated bit. Bron : Zen & The Art of C/SIDE Development Lees meer...

20 May 2016

Dynamics NAV & BC Tips & tricks

Is it still useful to buffer records in a temptable?

Maybe some of you remember my how-to increase performance by reducing db reads. I wrote it in 2007 when we still had the native DB and also the SQL DB but NOT the service tier with all its extra’s for performance. Bron : Totovic NAV Blog…

1 April 2016

Data & Analysis

Using Parameter Tables To Control Data Refresh In Power BI

The use of parameter tables is a well-known technique in Power Query. It involves using a table from the current Excel workbook to hold various parameter values that are read using a Power Query query, and these parameter values are then passed to another Power Query…

6 January 2016

Dynamics NAV & BC Tips & tricks

Using Argument Tables in Navision

When creating functions we sometimes need a lot of parameters to give the information we require. Number of arguments/parameters to function have limits. Sometimes these parameters are optional, only required in some scenarios. This makes calling them quite hard. Bron : Ashwini Tripathi Lees meer...

10 December 2015