Forum Discussion
Solved
Using two different data sources in one report
Here is a picture illustrating my scenario: I have two different data source that are loaded from SQL tables DataSource 1: damaged items DataSource 2: total process items They have some...
DimchoTsanov
The best practice and approach is to create separate dimension tables, either in SQL or Power Query. For example, you can create a single date table and link to both the source data tables using the One-To-Many relationship.
Follow the same for the other columns that are common in both tables.
DimchoTsanov
The best practice and approach is to create separate dimension tables, either in SQL or Power Query. For example, you can create a single date table and link to both the source data tables using the One-To-Many relationship.
Follow the same for the other columns that are common in both tables.