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

Merging queries

One of the most powerful (pun intended) benefits of Power BI is the ability to bring data in from multiple data sources. Frequently, these disparate data sources can be combined together as a single data source for easier visual creation.

Although our Vendors query and our AP Document Details query come from the same SQL Server database, we'll merge them together as a single query. This is not an uncommon practice. Occasionally, you'll likely find yourself in a position where you want to join separate tables or views within GP together into a single query. Let's add the vendor class and the address (from the Vendors query) to the AP Document Details query:

  1. In Query Editor, select the AP Document Details query in the Queries pane. ...

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