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
for example, if u get data from odbc
Try to create table with db_id like
and add new column with subquery like
=Table.AddColumn(Source, "Custom", each Odbc.Query([db_name],"select * from table_name"))
Next step expand data and create new primary key, merge db_name and primary key table.
Unfortunately, this model don't support scheduled update in power bi service.