dear experts, please help, i have customised report which i am try to get in excel through odbc following code in excel query written and i am getting an error as in image: in Narration field all other column value combined here. Regards, Kapil Code: let url = "http://localhost:9000", _body = "<ENVELOPE> <HEADER> <TALLYREQUEST>Exportdata</TALLYREQUEST> </HEADER> <BODY> <EXPORTDATA> <REQUESTDESC> <STATICVARIABLES> <SVEXPORTFORMAT>ASCII(Comma Delimited)</SVEXPORTFORMAT> <SVFROMDATE>DATE1</SVFROMDATE> <SVTODATE>DATE2</SVTODATE> </STATICVARIABLES> <REPORTNAME>K003Report</REPORTNAME> </REQUESTDESC> </EXPORTDATA> </BODY> </ENVELOPE>", FromDate = Date.ToText(#date(2022,02,03)), ToDate = Date.ToText(#date(2022,02,6)), body = Text.Replace(Text.Replace(_body, "DATE1", FromDate), "DATE2", ToDate), Source = Csv.Document(Text.Replace(Text.FromBinary(Web.Contents(url, [Content=Text.ToBinary(body, TextEncoding.Utf16), Headers=[#"Content-Type"="text/xml;charset=utf-16"]]), TextEncoding.Utf16),",#(cr,lf)", "#(cr,lf)"), {"SNo","Company Name","Date","Vch Type","Vch No","Ledger Name","Group Name","Group Parent Name","Narration","Ledger Amount","Dr/Cr","Fund Type","Funding Agency","Project","Budget Line","SubBudget Line","SubSubBudget Line","CostCentre Amount","CC Name","BA Title"}) in Source
First you are not using ODBC , you are using Tally XML server Next it is not Excel Query, It is Power Query(M Language) it is used in Power BI also Since you are using csv format and narration have comma, you are getting this problem Use XML Format and change query accordingly
YOUR WORK . PROPERLY , DEAR SIR PLEASE PROVIED AS SAME CODE FOR DAYBOOK VOCHER REGISTER WiTH COST CENTER NAME , just like JUST LIKE SEE