-
Book Overview & Buying
-
Table Of Contents
-
Feedback & Rating

Building Dashboards with Microsoft Dynamics GP 2016
By :

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:
In Query Editor, select the AP Document Details
query in the Queries pane. Although we can create an entirely new query by merging the two columns together, we'll just add the new column that we want from the Vendors
query in the AP Document Details
query.
Select the words Merge Queries from the Combine area of the ribbon...
Change the font size
Change margin width
Change background colour