cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DimchoTsanov
New Member

Using two different data sources in one report

Here is a picture illustrating my scenario: 

PowerBI-Scenario.png

  1. I have two different data source that are loaded from SQL tables
    1. DataSource 1: damaged items
    2. DataSource 2: total process items
  2. They have some columns in common - see the picture
  3. 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.
  4. Expected amount of data
    1. DataSource 1: 50K records
    2. 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?

1 ACCEPTED SOLUTION
Fowmy
Super User
Super User

@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.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

1 REPLY 1
Fowmy
Super User
Super User

@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.

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors