Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

Martin and Associates

Microsoft Dynamics GP Power BI Content Pack

Microsoft Dynamics GP Power BI Content Pack

Microsoft Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Whether your data is simple such as an Excel spreadsheet, or a collection of cloud-based or on-premises hybrid data warehouses, Power BI lets you easily connect to your data sources, visualize (or discover) what’s important, and share that with anyone or everyone you want.

The Power BI Desktop application is a tool that offers a contemporary method for generating reports using Microsoft Dynamics GP data. Reports can be displayed on your GP homepage, allowing you to see the most up-to-date information whenever you refresh.

With the release for Dynamics GP 2018, Microsoft introduced Power BI Dynamics GP content pack which includes pre-built reports for Financial, Purchasing, Sale and Inventory  data.

The content pack helps with the relationship between your Dynamics GP data, and includes filters you can use to display the data you want. Additionally, it includes Calculated Columns to use as examples to build your own; such as, net debit/credit, profit and item sales amounts. While the content pack contains sample reports meant to demonstrate the capabilities of Power BI, it is a great reference for designing your own Power BI reports for Dynamics GP.

Download the GP Power BI Content Pack

Questions? Or need help setting up Power BI?  Please contact your Account Rep or email cincinnati@martinandassoc.com.

Other Blog Posts

Using Document Templates in Acumatica

We often are asked about copying and pasting transactions in ERP systems; these questions come in various forms, such as asking about recurring transactions, or looking up a transaction from

Payroll Tax Update for Dynamics GP

Microsoft has released another Payroll Tax Update for Dynamics GP.  This is the fourth tax update for 2014. More importantly for our local clients: it contains tax changes for Ohio

WordPress Appliance - Powered by TurnKey Linux