Forum Discussion
Attach query and replicate formulas
PBi experts, I need your help again.
I need to annex month by month the same database but to copy automatically the measures or columns that I created in the first month.
When I use the attach query option it adds the rows but it does not copy the calculated measures or columns.
Is it possible to do this so I don't have to do the same formulas every month?
Thank you very much again!
HI JDU,
You can do merge operation on 'query editor' side, then you can only load the merge table to data model side as source data table. (cancel the loading of other queries)
Notice: create a table with connection strings and add a custom column to invoke each connection with connectors, then you can extract and merge new column data to a merge table.
Regards,
Xiaoxin Sheng
5 Replies
HI JDU,
Maybe you can try to parameterize your connection string and save your report as a template. Then you open the template to change its connection string to generate a new report with old report structures and designs.
Deep Dive into Query Parameters and Power BI Templates
Regards,
Xiaoxin Sheng
Thank you for your response.
Indeed the template serves to analyze different files separately, the problem is that I need to combine them as having a single report.HI JDU,
You can do merge operation on 'query editor' side, then you can only load the merge table to data model side as source data table. (cancel the loading of other queries)
Notice: create a table with connection strings and add a custom column to invoke each connection with connectors, then you can extract and merge new column data to a merge table.
Regards,
Xiaoxin Sheng
