Hi All,
I have a complex working dashboard created by an ex-employee, and I now wish to alter the data source, without needing to change the visuals.
I assumed that, so long as the column names end up the same, I could replace the query in the Advanced Editor, and the visualls would all work.
When I do this and CLose, I get the error message "The name "Contact Person" is already used for a column on the table "Business Info".
I interpret this to mean the Query is not self-contained, i.e. column info is somehow stored outside the query and not recreated when the query changes.
Is there a way to change the source of the query whilst not affecting the UI?
Here is my new query, it returns exactly the same column names as the resultant dataset of the previous query.
let
Source = Csv.Document(File.Contents("C:\Data\FullABR\ABR.CSV"),[Delimiter=",", Columns=46, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Use First Row as Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true])
in
#"Use First Row as Headers"
Here is the previous query
let
Source = RA,
#"Appended Query" = Table.Combine({Source, RB, RC, RD, RE, RF, RG, RH, RI, RJ, RK, RL, RM, RN, RO, RP, RQ, RR}),
--
-- (some columns reformatted etc)
--
#"Renamed Columns2" = Table.RenameColumns(#"Added Conditional Column1",{{"Business Location - Postcode", "Postcode"}})
in
#"Renamed Columns2"
