Forum Discussion
Append Queries Question
I have to do identical reports from 2 differerent PostgresSQL databases. Ideally, I would be able to merge the two queries so that I just have to create the report once. However, I would still like...
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