Forum Discussion
Solved
Append Queries - Add Source Table Column
I would like to have a column in an appended table which details the original table. For example, I have timesheets for individual team members which are appended to one table with all recorded time....
Create a Folder and put the excel files into the folder, then connect to the folder-> Load. In query editor, you will get below:
Then click the expand icon in the Content column, you can achieve the final result.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Refer, these power query solution. They will work in power bi too
https://chandoo.org/forum/threads/powerquery-append-include-column-with-sheet-name.31480/
Then Append :https://radacad.com/append-vs-merge-in-power-bi-and-power-query