O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Connecting to data in Dynamics GP

Now that we have made a simple Excel data connection, let's focus on getting data from Dynamics GP. The first step in connecting to data is knowing where the data resides. In the case of Dynamics GP, that would be a Microsoft SQL Server Database. No worries, you do not have to go into SQL, be an SQL God, or even know SQL. We'll provide you with tips to help you get to the data you want and make sure the data requires as little cleanup as possible. We'll discuss cleaning, which is also known as transforming, cleansing, editing, modeling, and so on, in a later chapter. There are three ways to get data from SQL into Power BI; we'll review those options in the following sections.

Direct SQL Connect

Let's begin with ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required