October 2015 – Page 7

Import data using copy and paste from Excel sheet or other source for PowerPivot Data Model.

You can copy & Paste data from an Excel workbook, or import data from a table on a web page, or any other source from which we can copy and paste into Excel. In the following steps, you add the data from a table. Bron :…

12 October 2015

Dynamics NAV & BC Tips & tricks

NAV 2013 R2: How to Back up a Live Database and Refresh a Test Database

If you have a test database, at some point in time you will be asked to refresh this with the current live data, especially when testing. I am often asked how to copy the live database into the test database so accurate testing of a development…

12 October 2015

Dynamics NAV & BC Tips & tricks

Code Coverage in NAV 2016

If you remember in previous versions there is a tool called code coverage which was very useful tool to trace the code / debug the error for the developers, but in NAV 2013 and higher version this was not available but an alternative application profiler was…

12 October 2015

Dynamics NAV & BC Tips & tricks

PowerPivot Creating a Data Model in Excel 2013

Before you can create a PivotTable, you’ll need some data. Let’s get some data from the Navision database. In Excel, open a blank workbook. You have several options for getting data from no of sources. Recall from my earlier post where we accessed data using web…

9 October 2015

Dynamics NAV & BC Tips & tricks

Coffee Break: Monitoring and troubleshooting NAV Services, Part III – Performance troubleshooting and profiling User Activity using PowerShell

Since the release of Microsoft Dynamics NAV 2013, tracing user activity has become a bit more complicated than it used to be in earlier versions due to the fact that unlike previously, all user connections to SQL Server are now server connections. Which makes it more…

9 October 2015

Dynamics NAV & BC Tips & tricks

Microsoft Dynamics NAV 2009 Classic Client – How to Set Up the Job Queue

I’m often asked to schedule processes in Microsoft Dynamics NAV. This blog explains how to do so in the Classic Client. From MSDN: Job Queues in Dynamics NAV enable you to specify, request, and control when certain processes are run, such as the processing of a…

8 October 2015

Dynamics NAV & BC Tips & tricks

PowerPivot for Excel

Power Pivot: Powerful data analysis and data modelling in Excel Power Pivot is an Excel add-in you can use to perform powerful data analysis and create sophisticated data models. With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis…

8 October 2015