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 Detailsquery 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 theVendorsquery in theAP Document Detailsquery.Select the words Merge Queries from the Combine area of the ribbon...