Error getting data in Power BI

[Analitika]

let
    Source = Odbc.Query(SelectServer, "Select *, mt_group.dbo.I02_DKH.I02_OP_DATA#(lf)#(lf)From SEKMES_TRIKAMPIS.dbo.I03_DKD#(lf)LEFT JOIN SEKMES_TRIKAMPIS.dbo.I02_DKH on SEKMES_TRIKAMPIS.dbo.I03_DKD.I03_KODAS_ZS=SEKMES_TRIKAMPIS.dbo.I02_DKH.I02_KODAS_ZS#(lf) and SEKMES_TRIKAMPIS.dbo.I03_DKD.I03_KODAS_DH=SEKMES_TRIKAMPIS.dbo.I02_DKH.I02_KODAS_DH"),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"I03_KODAS_ZS", "I03_KODAS_DH", "I03_EIL_NR", "I03_KODAS_SSD", "I03_KODAS_SSC", "I03_VAL_SUMD", "I03_VAL_SUMC", "I03_SUMA", "I03_KODAS_IS", "I03_KODAS_OS", "I03_KODAS_OS_S", "I03_SERIJA", "I03_ADDUSR", "I03_USERIS", "I03_R_DATE", "I02_IMON_ID", "I02_MODUL_NR", "I02_DOK_NR", "I02_OP_DATA", "I02_OP_APRAS", "I02_GEN_POZ", "I02_GEN_KARTAI", "I02_GEN_DIEN", "I02_PERKELTA", "I02_KODAS_SM", "I02_OP_DATA2"}),
    #"Replaced Value1" = Table.ReplaceValue(#"Removed Other Columns"," ","",Replacer.ReplaceText,{"I03_KODAS_ZS"}),
    #"Unpivoted Only Selected Columns" = Table.Unpivot(#"Replaced Value1", {"I03_VAL_SUMD", "I03_VAL_SUMC"}, "Attribute", "Value"),
    #"Added Custom" = Table.AddColumn(#"Unpivoted Only Selected Columns", "SAS_KOD", each if Text.Contains([Attribute], "SUMC") then [I03_KODAS_SSC] else if Text.Contains([Attribute], "SUMD") then [I03_KODAS_SSD] else null),
    #"Replaced Value2" = Table.ReplaceValue(#"Added Custom"," ","",Replacer.ReplaceText,{"SAS_KOD"}),
    #"Added Custom1" = Table.AddColumn(#"Replaced Value2", "DK klase1", each Text.Start([SAS_KOD],1)),
    #"Added Custom3" = Table.AddColumn(#"Added Custom1", "DK klase 2", each Text.Start([SAS_KOD],2)),
    #"Renamed Columns" = Table.RenameColumns(#"Added Custom3",{{"Value", "Suma"}}),
    #"Added Custom2" = Table.AddColumn(#"Renamed Columns", "D or C", each if [Attribute]="I03_VAL_SUMD" then "D" else 
if [Attribute]="I03_VAL_SUMC" then "C" else "Kazkas negerai"),
    #"Replaced Value" = Table.ReplaceValue(#"Added Custom2"," ","",Replacer.ReplaceText,{"I02_DOK_NR"}),
    #"Added Custom4" = Table.AddColumn(#"Replaced Value", "Sask numeris", each [I02_DOK_NR]&[I02_MODUL_NR]),
    #"Added Custom5" = Table.AddColumn(#"Added Custom4", "Raktas A", each [I03_KODAS_ZS]&[I03_KODAS_DH]),
    #"Added Custom6" = Table.AddColumn(#"Added Custom5", "B kodas unikalus", each [I03_KODAS_ZS]&[I02_MODUL_NR]),
    #"Duplicated Column" = Table.DuplicateColumn(#"Added Custom6", "I02_OP_DATA2", "I02_OP_DATA2 - Copy"),
    #"Extracted Year" = Table.TransformColumns(#"Duplicated Column",{{"I02_OP_DATA2 - Copy", Date.Year, Int64.Type}}),
    #"Renamed Columns1" = Table.RenameColumns(#"Extracted Year",{{"I02_OP_DATA2 - Copy", "I02_OP_DATA_metai"}}),
    #"Extracted Date" = Table.TransformColumns(#"Renamed Columns1",{{"I02_OP_DATA2", DateTime.Date, type date}}),
    #"Removed Columns" = Table.RemoveColumns(#"Extracted Date",{"Suma"}),
    #"Capitalized Each Word" = Table.TransformColumns(#"Removed Columns",{{"I03_KODAS_IS", Text.Proper, type text}, {"I03_KODAS_OS", Text.Proper, type text}}),
    #"Replaced Value3" = Table.ReplaceValue(#"Capitalized Each Word"," ","",Replacer.ReplaceText,{"B kodas unikalus"})
in
    #"Replaced Value3"

In power query:

code above.

And at first step I am getting this error:

Expression.Error: The name 'SelectServer' wasn't recognized. Make sure it's spelled correctly.

I have odbc named mt.

[ronaldbalza2023]

Hi @Analitika , hope you are having a great day. on this line, change the SelectServer to the name of your odbc 😉

Source = Odbc.Query(SelectServer, "Select *, mt_group.dbo.I02_DKH.I02_OP_DATA#(lf)#(lf)From SEKMES_TRIKAMPIS.dbo.I03

[Analitika]

Source = Odbc.Query("MT group", "Select *, SEKMES_TRIKAMPIS.dbo.I02_DKH.I02_OP_DATA#(lf)#(lf)From SEKMES_TRIKAMPIS.dbo.I03_DKD#(lf)LEFT JOIN SEKMES_TRIKAMPIS.dbo.I02_DKH on SEKMES_TRIKAMPIS.dbo.I03_DKD.I03_KODAS_ZS=SEKMES_TRIKAMPIS.dbo.I02_DKH.I02_KODAS_ZS#(lf) and SEKMES_TRIKAMPIS.dbo.I03_DKD.I03_KODAS_DH=SEKMES_TRIKAMPIS.dbo.I02_DKH.I02_KODAS_DH"),
    #"Removed Other Columns" = Table.SelectColumns(Source,{"I03_KODAS_ZS", "I03_KODAS_DH", "I03_EIL_NR", "I03_KODAS_SSD", "I03_KODAS_SSC", "I03_VAL_SUMD", "I03_VAL_SUMC", "I03_SUMA", "I03_KODAS_IS", "I03_KODAS_OS", "I03_KODAS_OS_S", "I03_SERIJA", "I03_ADDUSR", "I03_USERIS", "I03_R_DATE", "I02_IMON_ID", "I02_MODUL_NR", "I02_DOK_NR", "I02_OP_DATA", "I02_OP_APRAS", "I02_GEN_POZ", "I02_GEN_KARTAI", "I02_GEN_DIEN", "I02_PERKELTA", "I02_KODAS_SM", "I02_OP_DATA2"}),

My odbc is MT group but I am getting an error:

Expression.Error: ODBC: The connection string is invalid. Format of the initialization string does not conform to specification starting at index 0.
Details:
MT group