Forum Discussion
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 columns in common - see the picture
- I need to create the above illustrated report. My issue is with the 3rd row - a visual that shows trend about selected time period (in the Filters) based on both data source. Also, when something is selected in the 1st rwo, the 3rd row (trend visual) should change and show related trend data.
- Expected amount of data
- DataSource 1: 50K records
- DataSource 2: 200K records
I read that the proper relations between the two source is the key but I don't know how to connect these two different sources.
If I try to merge the two tables in one - is this a good approach...I will have table with 250K recoords.
Can anyone advise me what is the recommended approach is such scenarios?
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.
1 Reply
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.