Forum Discussion
Append Queries Question
Anonymous,
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/displaying-source-table-name-in-append-field/td-p/485400
Anonymous Try adding an additional field in your SELECT statement (using SQL Statment) option while importing. Something, similar to this...
SELECT c1,c2,'TEST' as DB FROM TEST.Table1 UNION ALL SELECT c1,c2,'PRODUCTION' as DB FROM PRODUCTION.Table2
Thank you. I will try this when I have a chance. It will be more complicated than what you have provided because the name of the databases and the tables contained within them are longer than what I stated earlier. And as I am not an expert at SQL, I will have to figure out exactly how to write my statement.
Anonymous,
You may refer to the following post.
https://community.powerbi.com/t5/Desktop/displaying-source-table-name-in-append-field/td-p/485400
That worked. Thank you very much!