New Features in Power BI From June 2017 Release

image

Figure 1 – Explanation of Power BI from https://powerbi.microsoft.com

On June 12, Amanda Cofsky, Program Manager for Power BI, provided an overview of the new reporting features available as of June.  The link to download Power BI is…. http://powerbi.microsoft.com/desktop?WT.mc_id=Blog_Desktop_Update.

Here’s the complete list of June updates from Cofsky’s blog posting.

Reporting
  • Data bars for new table & matrix (preview)
  • Markers on line, area, & combo charts
  • Accessible reports
    • Consume Power BI reports with keyboard navigation and screen reader support
    • Create accessible reports
  • Visuals font family setting
  • Horizontal Image Slicer
  • Combo chart formatting updates
    • Force zeros to align between the two axes
    • Shade area of the line
  • Bing maps improvements
    • Map themes
    • Improved geo hierarchy experience
  • High density line sampling
Data connectivity
  • Custom Data Connectors support
  • Power BI service Live Connect to On Premises and Push streaming datasets
  • Impala connector is now generally available
  • Amazon Redshift connector is now generally available
  • SAP BW connector – DirectQuery support (beta)
  • IBM Netezza connector (beta)
Query editing
  • “Add Column from Examples” enhancements

You can watch a video of the new features by clicking on https://youtu.be/YlNVE5dgcSI (Power BI Desktop Update – June 2017).  Remember that YouTube links can change from time to time so this link may change over time.


Microsoft Dynamics NAV W1 2017 Cumulative Update 7 Commercial Demo

image

Figure 1 – Home page for Sales Order Processor in Dynamics NAV 2017

You can now download the Commercial Demo for Dynamics NAV 2017 CU 7 at https://mibuso.com/downloads/microsoft-dynamics-nav-w1-2017-cumulative-update-7-build-16996.

To read through all of the new features in NAV 2017 CU 7, please go to the same link.  See some of the information from MIBUSO below.

Features in NAV 2017 CU 7

In Office 365 experience –  You can navigate effortlessly between your Microsoft Dynamics NAV data and your office tools – for example, Microsoft Outlook, Microsoft Bookings, or Microsoft Excel.

Embedded Power BI – Continuing the powerful integration, you can now use embedded Power BI to easily create insightful charts and reports, and then make them available within your Microsoft Dynamics NAV 2017 role center.

Setup and configuration – Getup and running faster. Save time & avoid unnecessary manual tasks with the assisted setup wizard that helps you import data, setup integration with Office 365, and enjoy a simplified setup experience, with predefined setup data and limited customer interaction.

User Experience – You can accomplish even more in your browser-based interface. For example, switch views to see and identify your list of records, including seeing picture thumbnails in different sizes, and use wizards to learn new concepts or simplify data entry.

Finance – Work with ready-to-use financial statements  and gain accessible insights into the financial performance of your business. The new  default Account Schedules means that no setup is required, making it quick to produce financial reports that you need, and point in time reporting means you can view the financial state of your business for any given time.

Cumulative Update 06 for Microsoft Dynamics NAV 2017 has been released

Cumulative Update 06 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2017.

Where to find Cumulative Update 06

You can download the cumulative update from KB 4021396  – Cumulative Update 6 for Microsoft Dynamics NAV 2017.

You can press one of the countries in list above for a direct download or you can download the cumulative update from the Microsoft Download Center.

To learn more about other Cumulative Updates already released for Microsoft Dynamics NAV 2017 please see KB  3210255.

Cumulative Update 31 for Microsoft Dynamics NAV 2015 has been released

Cumulative Update 31 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2015.

You can download the cumulative update from KB 4021394  – Cumulative Update 31 for Microsoft Dynamics NAV 2015.

Or you can download the cumulative update from the Microsoft Download Center.

For a list of all cumulative updates for this version, see Released Cumulative Updates for Microsoft Dynamics NAV 2015.

Cumulative Update 19 for Microsoft Dynamics NAV 2016 has been released

Cumulative Update 19 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.

You can download the cumulative update from the Microsoft Download Center.

You can see changes included in this cumulative update from KB 4021395 – Cumulative Update 19 for Microsoft Dynamics NAV 2016.

Jet Reports New Release for Dynamics GP and NAV

                        clip_image002

Jet Reports Canada sent out a notice this morning announcing that Jet Reports has released a new build.  All the details are below.

Three Excel Tricks for Lining up Data for Import into Dynamics NAV, GP, AX

image

Recently, I have had to import lots of different data for clients.  They give me Excel worksheets that are full of names, numbers and telephone numbers.  If you are working with Dynamics NAV or GP, you know that some of the fields can be very fussy in the import.  Dynamics AX is more forgiving.  I clean up the data, and get it ready. 

Most clients ask me how I clean up columns, especially phone numbers. If you use Excel a lot, you will know these formulas or tricks.  This post is for those who do not have to do this very often, and need some help.

1. Using Excel to change Words from All CAP to All lowercase, or to PROPER

    • you can use the UPPER, LOWER, or PROPER functions to automatically change the case of existing text to uppercase, lowercase, or proper case.
    • First, insert a temporary column next to the column that contains the text you want to convert
    • In the temporary column, for example,  cell B2, type =PROPER(A2)
    • The other choices are  =UPPER(A2) or  =LOWER(A2)

Now, all of the names, countries, states, provinces, etc. can have standardized type.

2. Removing spaces and symbols in a phone number

    • Often we get a list of telephone numbers that look like this

image

    • To get rid of the (, ), –, Ext. 0000, use the find and replace function
    • To get rid of the space, use the find and replace, using the space bar
      1. Press Ctrl + Space to select all cells in a column.
      2. Press Ctrl + H to open the “Find & Replace” dialog box.
      3. Press Space bar in the Find What field and make sure the “Replace with” field is empty.

3.  Filling in the extension on a phone number

    • Now  you want to add trailing zeroes to make all the numbers with a fixed length, such as 14 digits for a telephone number in Canada and the US
    • Create a blank column right of the existing phone number
    • Use the EXCEL function =A2&REPT(“0”,14-LEN(A2)) where “A” represents the column with the telephone number in it
    • The results are

image

      And, the number now becomes easy to import.

Dynamics NAV 2017 Cumulative Update 01

 

image

Picture from Groovypost.com

 

What would life be without updates?

To me, the answer is that it would be more frustrating and less fun.  Having said that, some exciting news!  As of December 7, Microsoft has release cumulative update 01 (CU01) for Dynamics NAV 2017.  You can read the entire blog at https://blogs.msdn.microsoft.com/nav/2016/12/07/cumulative-update-01-for-microsoft-dynamics-nav-2017-has-been-released/.

Where to find Cumulative Update 01

You can download the cumulative update from KB 3209071 – Cumulative Update 01 for Microsoft Dynamics NAV 2017 (Build 14199).

Or you can download the cumulative update from the Microsoft Download Center.

You will also find information on how to install the update – or at least a link to the article – on this blog.

Learn About Microsoft Dynamics NAV 2017

imageimage

Figure 1 – images from various sources

Microsoft has been on a role with releasing new software.  And, Dynamics NAV 2017 is looking very exciting for end users as well as developers. 

Lots of people have lots to say about it.  So, I put together a list of different blogs and articles that you might find as interesting as I did.  It can be a little light reading for the weekend.

1.  Waldo’s blog has some great details and some comments on the new opportunities.  See his information at http://www.waldo.be/2016/09/13/microsoft-dynamics-nav-2017-whats-new/

2. On the Community NAV blog, Tharanga Chandrasekara focuses on Microsoft’s release document on What’s New in NAV 2017.  It is a good read.  https://community.dynamics.com/nav/b/tharangacnavblog/archive/2016/09/17/what-is-new-in-microsoft-dynamics-nav-2017

3. If you are a developer, you may want to check out the info on the NAV TECH DAYS site at https://www.navtechdays.com/2016/sessions.  This covers things like “Building Extensions for NAV”, and Design Patterns in NAV 2017.

4.  To learn more about NAV 2017 Notifications, check out Roberto Stefanetti NAV Blog – https://robertostefanettinavblog.wordpress.com/category/nav-2017/

5.  If you are into Dynamics NAV technology and programming, you may want to check out the DIRECTIONS EMEA conference. It is being held Oct 12 to 14.  They are talking about the next best practices and the new features.  See the website. http://www.directionsemea.com/. “Join 1600 attendees who have already registered for THE BIGGEST NAV EVENT!”

Dynamics NAV 2017 is off to a rocking start!

Dynamics NAV 2013 Has New Cumulative Updates Available as of September 2 2016

image

Figure 1 – Picture from an old Microsoft slide show

Dynamics NAV 2013 is part of the Dynamics NAV teams update efforts.  They have provided a cumulative update for each of Dynamics NAV 2013 R2, and Dynamics NAV 2013.  You can get the details of the builds and other information from the References below.

Where to find Cumulative Update 35 For NAV 2013 R2

You can download the cumulative update from KB 3188238 – Cumulative Update 35 for Microsoft Dynamics NAV 2013 R2 (Build 46774).

 

Where to find Cumulative Update 42 for NAV 2013

You can download the cumulative update from KB 3188237 – Cumulative Update 42 for Microsoft Dynamics NAV 2013 (Build 46772).

References:

1. https://blogs.msdn.microsoft.com/nav/2016/09/02/cumulative-update-42-for-microsoft-dynamics-nav-2013-has-been-released/

2. https://blogs.msdn.microsoft.com/nav/2016/09/02/cumulative-update-35-for-microsoft-dynamics-nav-2013-r2-has-been-released/