Attach query and replicate formulas

[JDU]

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!

[Anonymous]

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

[JDU]

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.

[Anonymous · Accepted solution]

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

[JDU]

Could you send an example? ...I tried to do it, but it didn't work out

[Anonymous]

Hi @JDU,

You can check the following sample formula and steps.

Sample table:

New query table based on sample table records:

let
    Source = Table.Combine(Table.AddColumn(Sample,"Data",each Sql.Database([Server],[Database]))[Data])
in
    Source

Notice: right-click on the first sample table to turn off the enable load option.

Regards,

Xiaoxin Sheng