2018 – Page 19 – Pardaan.com

Using Dimensions in Reporting for Dynamics NAV/365 Business Central

This post continues exploring the topic of Dimensions in Dynamics NAV (further, “NAV”) and Dynamics 365 Business Central (further, “D365BC”). Other posts have already discussed what Dimensions and Dimensions Values are; how to create; and assign them to Master Data and GL Accounts as well as…

30 July 2018

Dynamics NAV & BC Tips & tricks

Dynamics NAV 2018 – enable use of V2 extensions

Although this should technically be part of the base install, since V2 extensions are pushed as the “best thing since sliced bread”, it doesn’t seem like this is the case. Just try installing a base version of 2018 without using the Cronus database as the database.…

27 July 2018

Data & Analysis

Using Process Monitor To Find Out How Much Data Power Query Reads From A File

This post is really just a quick follow-on from my post earlier this week on using Process Monitor to troubleshoot Power Query performance issues with file-based data sources, which I suggest you read before carrying on. I realised, after playing around with Process Monitor some more,…

27 July 2018

Data & Analysis

Using Process Monitor To Troubleshoot Power Query Performance Issues With File Data Sources

Troubleshooting Power Query performance issues in Power BI and Excel can be difficult because it’s a bit of a black box: there’s nothing in the UI to tell you what’s going on inside the Power Query engine and the diagnostic logs are very difficult to interpret.…

26 July 2018

Dynamics NAV & BC Tips & tricks

Dynamics 365 Business Central – how to use timers in AL

When still working in Dynamics NAV, you can easily add a timer to your page to allow, for instance, refreshes of the page in intervals. For that, you could use a Control Add-In called “Ping Pong”. Since we have no ability to use .Net anymore in…

26 July 2018

Data & Analysis

Dynamic Period variance with DAX in #PowerBI

One of those days where I spent a reasonable amount of time trying to solve a tricky DAX expression and once I got it; I came to know it was not at all tricky. In fact, it was far too simple to admit the time spent…

25 July 2018

Dynamics NAV & BC Tips & tricks

Mail Sending Option in NAV 2017 with Cover Letter & Attachments –Part 2

Continuing from previous post, further in next step we will apply same feature discussed in earlier post to our custom documents and learn where all places we need to take care development to get it working. Bron : KSD Consultancy Lees meer...

25 July 2018