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.


Creating Reports for Power BI Phone Apps

image

Figure 1 – Visual of Sales Dashboard created in Power BI – from Maggie Sparkman’s article “Create reports optimized for the Power BI phone apps”

Maggie Sparkman published a great article on creating desktop reports in Power BI that will translate to the mobile apps on the phones.

Her article appears at https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-create-phone-report/?mobileclient=ios.

In her article, she provides clear, step-by-step instructions on creating the visual.  The article is well worth the read if you are into Power BI.

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.

Jet Express for Excel For Microsoft Dynamics GP

image

Dynamics GP reporting is changing and improving!  For all Dynamics GP users who have been finding the boundaries in reporting with Microsoft Report Manager, get excited!  Jet Reports and Microsoft have partnered up to create Jet Express For Excel.  The announcement was made in May.  You can read Tara Grant’s blog here.

https://www.jetreports.com/blog/2016/05/31/microsoft-and-jet-reports-partner-to-offer-flexible-reporting-included-with-microsoft-dynamics-gp/

The big news is that it is available in June 2016, and there are over 20 Jet Express report templates, built for Microsoft Dynamics GP.  According to Grant, these reports provide insight into sales, finance, A/P, A/R, inventory and more.

The Jet Express for Excel site is at https://jetreports.com/l/express-splash.htmlThe product is not up on the site yet, but should be soon.  You can see a recording of the pre-launch webinar at the site, and download the feature guide and comparison sheet.

NAV 2016 – Learn about Report Layouts per Customer

CustomerRepLayouts

Figure 1 comes from http://totovic.com/2015/11/12/report-layouts-per-customer-in-nav-2016/.

From Aleksandar Totovic’s blog, learn about the different report settings in Dynamics NAV 2016.  The link is at  http://totovic.com/2015/11/12/report-layouts-per-customer-in-nav-2016/

Thank you, Aleksandar, for laying out the format for the rest of us.