Join Data Sources In Query. In Power BI desktop I have merged these 2 tables together and it works fine data is correctly merged. I have 2 tables from 2 different data source.
The following colored tables illustration will help us to understand the joined tables data matching in the query. Select Data Get Data From File From Workbook. After successfully testing connections to each data source you can proceed with running more complex queries.
Select Data Get Data From File From Workbook.
In this post well discuss the ability of Presto to query multiple data sources in a single query which in the context of Presto is referred to as Query Federation. On the Create tab in the Other group click Query Design. Double-click each data source that you want to use or select each data source and then click Add. When joining tables the fields that you join on must be the same data type.