PBI Data modeling - Combine from old system and new system ?

[ashmitp869]

Hi,

I have few table like dimension - projects , ServiceManager

and Facts tables FactActuals and FactBudgets coming from SQL Server.

Now I need to combine new system data that is projects coming from Web .

But there are different tables, not exactly the same.

My questions is , Can I append the new projects to the existing PBI , if I can create same sturcture as my old project.

i.e dim oldProjects,oldServiceManager

Facts oldFactActuals with newFactBudgets ?

Any solution pls.?

[ToddChitt · Accepted solution]

YES, you can! Do it in Power Query: Get the tables to have the same column names and data types as much as possible. Then do an Append Queries operation (your choice to generate a new query from the original two, or append one to the other). Lastly, disable the load of any source queries you don't need.

Hint: For things like this, I like to add a custome column to each source query called "Source" and give it a literal value like "Old System" or "New System". That way, when you are looking at any one row, you know which system it came from.

Hope that helps.