Solved: Error message in the Power query Editor & applied ...

Anonymous · ‎02-19-2019

Hello Power BI Community,

I was changing the source location of my files and I've faced several issue with one in particular.

1st I get this error message, that I was not gettind previously:

Formula.Firewall: Query 'Argo entries final modèle' (step 'Colonnes renommées') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

2nd when I wanted to change the source it worked for all my files eexcept this one who was is appearing in grey.

So since it is impossible to change the source this way, I went int the Advanced Editor and changed the source code

But it won't work and I release that Power BI generated 2 " in" in the code so that result in an issue that all the first applied steps have disappear even tho they are still in the Advance Editor code and are indeed applied to the data.

let
    #"Argo entries final modèle" = let
    Source = Csv.Document(File.Contents("C:\Users\MarkLOVEJOY\ESL Education\Argo - PowerBI_Data\Argo_P_and_L.txt"),[Delimiter="    ", Columns=33, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Reordered Columns1" = Table.ReorderColumns(#"Promoted Headers",{"Company", "Branch", "Contract_nr", "Contract_date", "Invoice_date", "Invoice_nr", "Client_type", "Service_type", "Revenue_acct", "Provider_expense_acct", "VAT_acct", "Commission_acct", "Provider_currency", "Gross_HT_PC", "VAT_PC", "Commission_PC", "Provider_amount_PC", "Invoice_currency", "Gross_HT_IC", "VAT_IC", "Commission_IC", "Provider_amount_IC", "Company_currency", "Gross_HT_CC", "VAT_CC", "Commission_CC", "Provider_amount_CC", "Global_currency", "Gross_HT_CHF", "VAT_CHF", "Commission_CHF", "Provider_amount_CHF"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Reordered Columns1",{{"Company", Int64.Type}, {"Branch", type text}, {"Contract_nr", type text}, {"Contract_date", type date}, {"Service_type", type text}, {"Revenue_acct", Int64.Type}, {"Provider_expense_acct", type text}, {"VAT_acct", Int64.Type}, {"Commission_acct", Int64.Type}, {"Provider_currency", type text}, {"Gross_HT_PC", type number}, {"VAT_PC", type number}, {"Commission_PC", type number}, {"Provider_amount_PC", type number}, {"Invoice_currency", type text}, {"Gross_HT_IC", type number}, {"VAT_IC", type number}, {"Commission_IC", type number}, {"Provider_amount_IC", type number}, {"Company_currency", type text}, {"Gross_HT_CC", type number}, {"VAT_CC", type number}, {"Commission_CC", type number}, {"Provider_amount_CC", type number}, {"Global_currency", type text}, {"Gross_HT_CHF", type number}, {"VAT_CHF", type number}, {"Commission_CHF", type number}, {"Provider_amount_CHF", type number}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","xxxx","",Replacer.ReplaceText,{"Provider_expense_acct"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","x","",Replacer.ReplaceText,{"Provider_expense_acct"}),
    #"Removed Columns" = Table.RemoveColumns(#"Replaced Value1",{"Global_currency", "Gross_HT_CHF", "VAT_CHF", "Commission_CHF", "Provider_amount_CHF", "Provider_currency", "Gross_HT_PC", "VAT_PC", "Commission_PC", "Provider_amount_PC", "Company_currency", "Gross_HT_CC", "VAT_CC", "Commission_CC", "Provider_amount_CC"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Company", "Branch", "Contract_nr", "Contract_date", "Service_type", "Invoice_currency", "Revenue_acct", "Provider_expense_acct", "VAT_acct", "Commission_acct", "Gross_HT_IC", "VAT_IC", "Commission_IC", "Provider_amount_IC"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Revenue_acct", "Revenue Acc"}, {"Provider_expense_acct", "Provider Acc"}, {"VAT_acct", "VAT Acc"}, {"Commission_acct", "Commission Acc"}, {"Gross_HT_IC", "Gross HT"}, {"VAT_IC", "VAT"}, {"Commission_IC", "Commission"}, {"Provider_amount_IC", "Provider Cost"}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Renamed Columns",{"Gross HT", "VAT", "Commission", "Provider Cost", "Invoice_currency"}),
    #"Reordered Columns6" = Table.ReorderColumns(#"Removed Columns1",{"Company", "Branch", "Contract_nr", "Contract_date", "Invoice_date", "Invoice_nr", "Allow_invoice_currency_entry", "Client_type", "Service_type", "Revenue Acc", "Provider Acc", "VAT Acc", "Commission Acc"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Reordered Columns6", {"Company", "Branch", "Contract_nr", "Contract_date", "Invoice_date", "Invoice_nr", "Allow_invoice_currency_entry", "Client_type", "Service_type"}, "Attribute", "Value"),
    #"Changed Type2" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Value", Int64.Type}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type2",{{"Value", Int64.Type}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Changed Type1",{{"Value", "Accounts N"}, {"Attribute", "Accounts Name"}}),
    #"Added Index" = Table.AddIndexColumn(#"Renamed Columns1", "Index", 0, 1),
    #"Merged Queries" = Table.NestedJoin(#"Added Index",{"Index"},#"Argo to merge CC",{"Index"},"Argo to merge CC",JoinKind.LeftOuter),
    #"Expanded Argo to merge CC" = Table.ExpandTableColumn(#"Merged Queries", "Argo to merge CC", {"Company_currency", "Attribute", "CC amount"}, {"Argo to merge CC.Company_currency", "Argo to merge CC.Attribute", "Argo to merge CC.CC amount"}),
    #"Removed Columns2" = Table.RemoveColumns(#"Expanded Argo to merge CC",{"Argo to merge CC.Attribute"}),
    #"Merged Queries1" = Table.NestedJoin(#"Removed Columns2",{"Index"},#"Argo to merge CHF",{"Index"},"Argo to merge CHF",JoinKind.LeftOuter),
    #"Expanded Argo to merge CHF" = Table.ExpandTableColumn(#"Merged Queries1", "Argo to merge CHF", {"Global currency", "Value"}, {"Argo to merge CHF.Global currency", "Argo to merge CHF.Value"}),
    #"Merged Queries2" = Table.NestedJoin(#"Expanded Argo to merge CHF",{"Index"},#"Argo to merge IC",{"Index"},"Argo to merge IC",JoinKind.LeftOuter),
    #"Expanded Argo to merge IC" = Table.ExpandTableColumn(#"Merged Queries2", "Argo to merge IC", {"Invoice_currency", "Value"}, {"Argo to merge IC.Invoice_currency", "Argo to merge IC.Value"}),
    #"Merged Queries3" = Table.NestedJoin(#"Expanded Argo to merge IC",{"Index"},#"Argo to merge PC",{"Index"},"Argo to merge PC",JoinKind.LeftOuter),
    #"Expanded Argo to merge PC" = Table.ExpandTableColumn(#"Merged Queries3", "Argo to merge PC", {"Provider currency", "Value"}, {"Argo to merge PC.Provider currency", "Argo to merge PC.Value"}),
    #"Renamed Columns2" = Table.RenameColumns(#"Expanded Argo to merge PC",{{"Argo to merge PC.Provider currency", "Provider currency"}, {"Argo to merge PC.Value", "PC amount"}, {"Argo to merge IC.Value", "IC amount"}, {"Argo to merge IC.Invoice_currency", "Invoice currency"}, {"Argo to merge CHF.Value", "GC amount"}, {"Argo to merge CHF.Global currency", "Global currency"}, {"Argo to merge CC.CC amount", "CC amount"}, {"Argo to merge CC.Company_currency", "Company currency"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns2", each ([Accounts N] <> null and [Accounts N] <> 22000)),
    #"Renamed Columns3" = Table.RenameColumns(#"Filtered Rows",{{"Branch", "Cost center"}, {"Contract_date", "Date"}, {"Invoice_date", "Invoice date"}}),
    #"Changed Type3" = Table.TransformColumnTypes(#"Renamed Columns3",{{"Invoice date", type date}}),
    #"Renamed Columns4" = Table.RenameColumns(#"Changed Type3",{{"Invoice_nr", "Entry Nb"}}),
    #"Reordered Columns2" = Table.ReorderColumns(#"Renamed Columns4",{"Company", "Cost center", "Contract_nr", "Date", "Invoice date", "Entry Nb", "Accounts Name", "Client_type", "Service_type", "Accounts N", "Index", "Company currency", "CC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Provider currency", "PC amount"}),
    #"Renamed Columns5" = Table.RenameColumns(#"Reordered Columns2",{{"Accounts Name", "Description"}, {"Client_type", "Client type"}, {"Service_type", "Service type"}, {"Accounts N", "Account"}}),
    #"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns5",{"Index"}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Removed Columns3", "PC amount", "PC amount - Copy"),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Duplicated Column", "Provider currency", "Provider currency - Copy"),
    #"Reordered Columns3" = Table.ReorderColumns(#"Duplicated Column1",{"Company", "Cost center", "Date", "Invoice date", "Entry Nb", "Description", "Client type", "Service type", "Account", "PC amount - Copy", "Provider currency - Copy", "Company currency", "CC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Provider currency", "PC amount"}),
    #"Renamed Columns7" = Table.RenameColumns(#"Reordered Columns3",{{"PC amount - Copy", "Integra IC"}}),
    #"Renamed Columns8" = Table.RenameColumns(#"Renamed Columns7",{{"Provider currency - Copy", "Source currency"}, {"Integra IC", "Source amount"}}),
    #"Renamed Columns6" = Table.RenameColumns(#"Renamed Columns8",{{"Allow_invoice_currency_entry", "Allow Invoice TRUE/FALSE"}}),
    #"Colonnes permutées" = Table.ReorderColumns(#"Renamed Columns6",{"Company", "Cost center", "Date", "Invoice date", "Contract_nr", "Allow Invoice TRUE/FALSE", "Description", "Client type", "Service type", "Account", "Source amount", "Source currency", "Company currency", "CC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Provider currency", "PC amount"}),
    #"Colonnes renommées" = Table.RenameColumns(#"Colonnes permutées",{{"Contract_nr", "Entry Nb2"}}),
    #"Personnalisée ajoutée" = Table.AddColumn(#"Colonnes renommées", "x1", each 0),
    #"Duplication de la colonne" = Table.DuplicateColumn(#"Personnalisée ajoutée", "x1", "x1 - Copier"),
    #"Duplication de la colonne1" = Table.DuplicateColumn(#"Duplication de la colonne", "x1", "x1 - Copier.1"),
    #"Duplication de la colonne2" = Table.DuplicateColumn(#"Duplication de la colonne1", "x1", "x1 - Copier.2"),
    #"Duplication de la colonne3" = Table.DuplicateColumn(#"Duplication de la colonne2", "x1", "x1 - Copier.3"),
    #"Duplication de la colonne4" = Table.DuplicateColumn(#"Duplication de la colonne3", "x1", "x1 - Copier.4"),
    #"Duplication de la colonne5" = Table.DuplicateColumn(#"Duplication de la colonne4", "x1", "x1 - Copier.5")
in
    #"Duplication de la colonne1",
    #"Duplication de la colonne" = Table.DuplicateColumn(#"Argo entries final modèle", "x1", "x1 - Copier.2"),
    #"Duplication de la colonne1" = Table.DuplicateColumn(#"Duplication de la colonne", "x1", "x1 - Copier.3"),
    #"Duplication de la colonne2" = Table.DuplicateColumn(#"Duplication de la colonne1", "x1", "x1 - Copier.4"),
    #"Colonnes permutées" = Table.ReorderColumns(#"Duplication de la colonne2",{"Company", "Cost center", "Date", "Invoice date", "Entry Nb", "Allow Invoice TRUE/FALSE", "Description", "Client type", "Service type", "Account", "Source currency", "Source amount", "Company currency", "CC amount", "Provider currency", "PC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Entry Nb2", "x1", "x1 - Copier", "x1 - Copier.1", "x1 - Copier.2", "x1 - Copier.3", "x1 - Copier.4"}),
    #"Colonnes renommées" = Table.RenameColumns(#"Colonnes permutées",{{"Entry Nb2", "Internal no"}, {"x1", "Supplier name"}, {"x1 - Copier", "Supplier invoice no"}, {"x1 - Copier.1", "Project name"}, {"x1 - Copier.2", "Project staff"}, {"x1 - Copier.3", "User initials"}, {"x1 - Copier.4", "Date created"}})
in
    #"Colonnes renommées"

Any ideas?

Thanks

Mark Lovejoy

v-frfei-msft · ‎02-28-2019

Hi @Anonymous ,

Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

View solution in original post

Anonymous · ‎02-19-2019

Hello Power BI Community,

I was changing the source location of my files and I've faced several issue with one in particular.

1st I get this error message, that I was not gettind previously:

Formula.Firewall: Query 'Argo entries final modèle' (step 'Colonnes renommées') references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

2nd when I wanted to change the source it worked for all my files eexcept this one who was is appearing in grey.

So since it is impossible to change the source this way, I went int the Advanced Editor and changed the source code

But it won't work and I release that Power BI generated 2 " in" in the code so that result in an issue that all the first applied steps have disappear even tho they are still in the Advance Editor code and are indeed applied to the data.

let
    #"Argo entries final modèle" = let
    Source = Csv.Document(File.Contents("C:\Users\MarkLOVEJOY\ESL Education\Argo - PowerBI_Data\Argo_P_and_L.txt"),[Delimiter="    ", Columns=33, Encoding=1252, QuoteStyle=QuoteStyle.None]),
    #"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
    #"Reordered Columns1" = Table.ReorderColumns(#"Promoted Headers",{"Company", "Branch", "Contract_nr", "Contract_date", "Invoice_date", "Invoice_nr", "Client_type", "Service_type", "Revenue_acct", "Provider_expense_acct", "VAT_acct", "Commission_acct", "Provider_currency", "Gross_HT_PC", "VAT_PC", "Commission_PC", "Provider_amount_PC", "Invoice_currency", "Gross_HT_IC", "VAT_IC", "Commission_IC", "Provider_amount_IC", "Company_currency", "Gross_HT_CC", "VAT_CC", "Commission_CC", "Provider_amount_CC", "Global_currency", "Gross_HT_CHF", "VAT_CHF", "Commission_CHF", "Provider_amount_CHF"}),
    #"Changed Type" = Table.TransformColumnTypes(#"Reordered Columns1",{{"Company", Int64.Type}, {"Branch", type text}, {"Contract_nr", type text}, {"Contract_date", type date}, {"Service_type", type text}, {"Revenue_acct", Int64.Type}, {"Provider_expense_acct", type text}, {"VAT_acct", Int64.Type}, {"Commission_acct", Int64.Type}, {"Provider_currency", type text}, {"Gross_HT_PC", type number}, {"VAT_PC", type number}, {"Commission_PC", type number}, {"Provider_amount_PC", type number}, {"Invoice_currency", type text}, {"Gross_HT_IC", type number}, {"VAT_IC", type number}, {"Commission_IC", type number}, {"Provider_amount_IC", type number}, {"Company_currency", type text}, {"Gross_HT_CC", type number}, {"VAT_CC", type number}, {"Commission_CC", type number}, {"Provider_amount_CC", type number}, {"Global_currency", type text}, {"Gross_HT_CHF", type number}, {"VAT_CHF", type number}, {"Commission_CHF", type number}, {"Provider_amount_CHF", type number}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type","xxxx","",Replacer.ReplaceText,{"Provider_expense_acct"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value","x","",Replacer.ReplaceText,{"Provider_expense_acct"}),
    #"Removed Columns" = Table.RemoveColumns(#"Replaced Value1",{"Global_currency", "Gross_HT_CHF", "VAT_CHF", "Commission_CHF", "Provider_amount_CHF", "Provider_currency", "Gross_HT_PC", "VAT_PC", "Commission_PC", "Provider_amount_PC", "Company_currency", "Gross_HT_CC", "VAT_CC", "Commission_CC", "Provider_amount_CC"}),
    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns",{"Company", "Branch", "Contract_nr", "Contract_date", "Service_type", "Invoice_currency", "Revenue_acct", "Provider_expense_acct", "VAT_acct", "Commission_acct", "Gross_HT_IC", "VAT_IC", "Commission_IC", "Provider_amount_IC"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Revenue_acct", "Revenue Acc"}, {"Provider_expense_acct", "Provider Acc"}, {"VAT_acct", "VAT Acc"}, {"Commission_acct", "Commission Acc"}, {"Gross_HT_IC", "Gross HT"}, {"VAT_IC", "VAT"}, {"Commission_IC", "Commission"}, {"Provider_amount_IC", "Provider Cost"}}),
    #"Removed Columns1" = Table.RemoveColumns(#"Renamed Columns",{"Gross HT", "VAT", "Commission", "Provider Cost", "Invoice_currency"}),
    #"Reordered Columns6" = Table.ReorderColumns(#"Removed Columns1",{"Company", "Branch", "Contract_nr", "Contract_date", "Invoice_date", "Invoice_nr", "Allow_invoice_currency_entry", "Client_type", "Service_type", "Revenue Acc", "Provider Acc", "VAT Acc", "Commission Acc"}),
    #"Unpivoted Columns" = Table.UnpivotOtherColumns(#"Reordered Columns6", {"Company", "Branch", "Contract_nr", "Contract_date", "Invoice_date", "Invoice_nr", "Allow_invoice_currency_entry", "Client_type", "Service_type"}, "Attribute", "Value"),
    #"Changed Type2" = Table.TransformColumnTypes(#"Unpivoted Columns",{{"Value", Int64.Type}}),
    #"Changed Type1" = Table.TransformColumnTypes(#"Changed Type2",{{"Value", Int64.Type}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Changed Type1",{{"Value", "Accounts N"}, {"Attribute", "Accounts Name"}}),
    #"Added Index" = Table.AddIndexColumn(#"Renamed Columns1", "Index", 0, 1),
    #"Merged Queries" = Table.NestedJoin(#"Added Index",{"Index"},#"Argo to merge CC",{"Index"},"Argo to merge CC",JoinKind.LeftOuter),
    #"Expanded Argo to merge CC" = Table.ExpandTableColumn(#"Merged Queries", "Argo to merge CC", {"Company_currency", "Attribute", "CC amount"}, {"Argo to merge CC.Company_currency", "Argo to merge CC.Attribute", "Argo to merge CC.CC amount"}),
    #"Removed Columns2" = Table.RemoveColumns(#"Expanded Argo to merge CC",{"Argo to merge CC.Attribute"}),
    #"Merged Queries1" = Table.NestedJoin(#"Removed Columns2",{"Index"},#"Argo to merge CHF",{"Index"},"Argo to merge CHF",JoinKind.LeftOuter),
    #"Expanded Argo to merge CHF" = Table.ExpandTableColumn(#"Merged Queries1", "Argo to merge CHF", {"Global currency", "Value"}, {"Argo to merge CHF.Global currency", "Argo to merge CHF.Value"}),
    #"Merged Queries2" = Table.NestedJoin(#"Expanded Argo to merge CHF",{"Index"},#"Argo to merge IC",{"Index"},"Argo to merge IC",JoinKind.LeftOuter),
    #"Expanded Argo to merge IC" = Table.ExpandTableColumn(#"Merged Queries2", "Argo to merge IC", {"Invoice_currency", "Value"}, {"Argo to merge IC.Invoice_currency", "Argo to merge IC.Value"}),
    #"Merged Queries3" = Table.NestedJoin(#"Expanded Argo to merge IC",{"Index"},#"Argo to merge PC",{"Index"},"Argo to merge PC",JoinKind.LeftOuter),
    #"Expanded Argo to merge PC" = Table.ExpandTableColumn(#"Merged Queries3", "Argo to merge PC", {"Provider currency", "Value"}, {"Argo to merge PC.Provider currency", "Argo to merge PC.Value"}),
    #"Renamed Columns2" = Table.RenameColumns(#"Expanded Argo to merge PC",{{"Argo to merge PC.Provider currency", "Provider currency"}, {"Argo to merge PC.Value", "PC amount"}, {"Argo to merge IC.Value", "IC amount"}, {"Argo to merge IC.Invoice_currency", "Invoice currency"}, {"Argo to merge CHF.Value", "GC amount"}, {"Argo to merge CHF.Global currency", "Global currency"}, {"Argo to merge CC.CC amount", "CC amount"}, {"Argo to merge CC.Company_currency", "Company currency"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns2", each ([Accounts N] <> null and [Accounts N] <> 22000)),
    #"Renamed Columns3" = Table.RenameColumns(#"Filtered Rows",{{"Branch", "Cost center"}, {"Contract_date", "Date"}, {"Invoice_date", "Invoice date"}}),
    #"Changed Type3" = Table.TransformColumnTypes(#"Renamed Columns3",{{"Invoice date", type date}}),
    #"Renamed Columns4" = Table.RenameColumns(#"Changed Type3",{{"Invoice_nr", "Entry Nb"}}),
    #"Reordered Columns2" = Table.ReorderColumns(#"Renamed Columns4",{"Company", "Cost center", "Contract_nr", "Date", "Invoice date", "Entry Nb", "Accounts Name", "Client_type", "Service_type", "Accounts N", "Index", "Company currency", "CC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Provider currency", "PC amount"}),
    #"Renamed Columns5" = Table.RenameColumns(#"Reordered Columns2",{{"Accounts Name", "Description"}, {"Client_type", "Client type"}, {"Service_type", "Service type"}, {"Accounts N", "Account"}}),
    #"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns5",{"Index"}),
    #"Duplicated Column" = Table.DuplicateColumn(#"Removed Columns3", "PC amount", "PC amount - Copy"),
    #"Duplicated Column1" = Table.DuplicateColumn(#"Duplicated Column", "Provider currency", "Provider currency - Copy"),
    #"Reordered Columns3" = Table.ReorderColumns(#"Duplicated Column1",{"Company", "Cost center", "Date", "Invoice date", "Entry Nb", "Description", "Client type", "Service type", "Account", "PC amount - Copy", "Provider currency - Copy", "Company currency", "CC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Provider currency", "PC amount"}),
    #"Renamed Columns7" = Table.RenameColumns(#"Reordered Columns3",{{"PC amount - Copy", "Integra IC"}}),
    #"Renamed Columns8" = Table.RenameColumns(#"Renamed Columns7",{{"Provider currency - Copy", "Source currency"}, {"Integra IC", "Source amount"}}),
    #"Renamed Columns6" = Table.RenameColumns(#"Renamed Columns8",{{"Allow_invoice_currency_entry", "Allow Invoice TRUE/FALSE"}}),
    #"Colonnes permutées" = Table.ReorderColumns(#"Renamed Columns6",{"Company", "Cost center", "Date", "Invoice date", "Contract_nr", "Allow Invoice TRUE/FALSE", "Description", "Client type", "Service type", "Account", "Source amount", "Source currency", "Company currency", "CC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Provider currency", "PC amount"}),
    #"Colonnes renommées" = Table.RenameColumns(#"Colonnes permutées",{{"Contract_nr", "Entry Nb2"}}),
    #"Personnalisée ajoutée" = Table.AddColumn(#"Colonnes renommées", "x1", each 0),
    #"Duplication de la colonne" = Table.DuplicateColumn(#"Personnalisée ajoutée", "x1", "x1 - Copier"),
    #"Duplication de la colonne1" = Table.DuplicateColumn(#"Duplication de la colonne", "x1", "x1 - Copier.1"),
    #"Duplication de la colonne2" = Table.DuplicateColumn(#"Duplication de la colonne1", "x1", "x1 - Copier.2"),
    #"Duplication de la colonne3" = Table.DuplicateColumn(#"Duplication de la colonne2", "x1", "x1 - Copier.3"),
    #"Duplication de la colonne4" = Table.DuplicateColumn(#"Duplication de la colonne3", "x1", "x1 - Copier.4"),
    #"Duplication de la colonne5" = Table.DuplicateColumn(#"Duplication de la colonne4", "x1", "x1 - Copier.5")
in
    #"Duplication de la colonne1",
    #"Duplication de la colonne" = Table.DuplicateColumn(#"Argo entries final modèle", "x1", "x1 - Copier.2"),
    #"Duplication de la colonne1" = Table.DuplicateColumn(#"Duplication de la colonne", "x1", "x1 - Copier.3"),
    #"Duplication de la colonne2" = Table.DuplicateColumn(#"Duplication de la colonne1", "x1", "x1 - Copier.4"),
    #"Colonnes permutées" = Table.ReorderColumns(#"Duplication de la colonne2",{"Company", "Cost center", "Date", "Invoice date", "Entry Nb", "Allow Invoice TRUE/FALSE", "Description", "Client type", "Service type", "Account", "Source currency", "Source amount", "Company currency", "CC amount", "Provider currency", "PC amount", "Global currency", "GC amount", "Invoice currency", "IC amount", "Entry Nb2", "x1", "x1 - Copier", "x1 - Copier.1", "x1 - Copier.2", "x1 - Copier.3", "x1 - Copier.4"}),
    #"Colonnes renommées" = Table.RenameColumns(#"Colonnes permutées",{{"Entry Nb2", "Internal no"}, {"x1", "Supplier name"}, {"x1 - Copier", "Supplier invoice no"}, {"x1 - Copier.1", "Project name"}, {"x1 - Copier.2", "Project staff"}, {"x1 - Copier.3", "User initials"}, {"x1 - Copier.4", "Date created"}})
in
    #"Colonnes renommées"

Any ideas?

Thanks

Mark Lovejoy

v-frfei-msft · ‎02-20-2019

Hi @Anonymous ,

Please enable the opetion Ignore the Privacy Levels and potentially improve performance to have a try again.

Or you can refer to this bolg to slove the issue.

https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

Regards,

Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

v-frfei-msft · ‎02-28-2019

Hi @Anonymous ,

Has your issue been solved? If so, kindly mark my answer as a solution to close the case. If any other question, feel free to let me know please.

Regards,
Frank

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Anonymous · ‎02-28-2019

Well no actually this was not the solution but I was able to make it work now.

Thanks for your time.

Mark

Error message in the Power query Editor & applied steps disapeard

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly