Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.?
Solved! Go to 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.
Proud to be a Super User! | |
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.
Proud to be a Super User! | |
User | Count |
---|---|
88 | |
72 | |
69 | |
65 | |
57 |
User | Count |
---|---|
96 | |
92 | |
91 | |
75 | |
69 |