MDGP 2016 R1 Feature of the Day: OData Service

The previous feature of the day introduced the OData Service installation. This one gives a brief overview of how the service works:

OData Service

The main features of the OData service are:

  • Ability to define end points for the service
  • View GP data with any tool that supports OData feeds

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: OData Service Deployment

Microsoft Dynamics GP 2016 R1 is seeing the introduction of a new complimentary product: an OData service which will allow reports on Dynamics GP data using any reporting tool (such as PoweBI) to be created:

OData Service Deployment

The main features of are:

  • Separate install under Additional Products
  • Use GP Security to control access to data
  • Supports tables, views and stored procs as data sources

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index

MDGP 2016 R1 Feature of the Day: PowerBI Reports on the Home Page

In February 2014 Microsoft launched PowerBI for Office 265 and are now bringing it to the Microsoft Dynamics GP 2016 R1 home page (but only the home page of the desktop client):

PowerBI on the Microsoft Dynamics GP 2016 R1 home page

The main features of are:

  • New part on Home Page to display Power BI Reports.
  • Click on the report to take you out to your Power BI site.

I’m not entirely sure how to feel about the addition of PowerBI to Dynamics GP; it almost feels like a scatter gun approach is being used for reporting with Dynamics GP. There are standard reports, Metrics, Excel Reports, SSRS Reports (which for most clients replace the Metrics to the extent I had to lookup the name of Metrics), Management Reporter (with an unknown roadmap/future) reports and now PowerBI reports.

Click to show/hide the MDGP 2016 R1 Feature of the Day Series Index