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.
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:
AP Document Detailsquery in the Queries pane. ...