Key – Page 2 – Pardaan.com

Understanding The “The key didn’t match any rows in the table” Error In Power Query In Power BI Or Excel

One of the most common errors you’ll see when working with Power Query in Power BI or Excel is this: Expression.Error: The key didn’t match any rows in the table Source : Chris Webb's BI Blog Read more...

14 April 2020

Dynamics NAV & BC Tips & tricks

All the shortcut keys in Business Central v16

I’m working on the Microsoft Dynamics 365 Business Central Field Guide for version 16, and I want to make sure the shortcut chapter is updated. So I wrote a small script to extract all the shortcuts found in the current preview release version, here they are:…

25 March 2020

Dynamics NAV & BC Tips & tricks

Unique Keys what you can do and what you cannot?

The unique key functionality is something brand new and released in Spring Release 2019. It was briefly discussed on Soren’s blog (link here) but I decided to check and write you little more about what I found. Source : M Y N A V B L…

15 April 2019

Dynamics NAV & BC Tips & tricks

Disable specific Keyboard Keys – Single Line of Code

I saw many people asking how to disable specific keys from Keyboards like for example How to Disable Enter Key , Though I never got this need :) but eventually requirements has no limits hence I decided to find it out and introduce it here in…

29 March 2016

Dynamics NAV & BC Tips & tricks

Tip #54 | PowerShell Merge – A clustered key can appear only once in a table

If you upgrade your database to NAV2016 using the PowerShell Merge commandlets and have a change to table 49 you will run into this issue. Table 49 is the Invoice Posting Buffer table that NAV uses to create G/L entries for each unique combination of values…

19 November 2015

Dynamics NAV & BC Tips & tricks

How to create a root CA and a private key file by using the makecert.exe utility

We will follow below step to create a certificate for Microsoft Dynamics Server. Then we will implement the same for login from WAN to access Navision using Windows and Web Clients. On the computer running Microsoft Dynamics NAV Server, create a temporary folder to use when…

12 August 2015

Dynamics NAV & BC Tips & tricks

Key impact on database size

I am not sure about the article that i am writing that i Should Write it or not. The area that i am about to discuss is something where i am a newbie and would like to explore the area. The Reason behind article was something…

13 July 2015