Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
I appended table #2 and table #3 to table #1. When I edit the query for table #1 I don't see that anywhere. I mean data is there I'm just curious if there is a way to track this?
Thanks
Solved! Go to Solution.
Just create a new step before your append steps. ( In Applied Steps over on the right in PQ )
@danextian that sounds like a good idea but unfortunately I have already done append
Just create a new step before your append steps. ( In Applied Steps over on the right in PQ )
Hi @stribor45 ,
For each table that you append add a column called Source or any other name to the original table. The input is the name of your source say "Table 1". There should now be a Source column in the combined table. Load this into the model together with the other columns.
Proud to be a Super User!
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
66 | |
55 |