score:3

Accepted answer
xnamespace ns = @"urn:schemas-microsoft-com:xml-analysis:rowset";
ienumerable resultset = (from result in xmldoc.root.descendants(ns + "row")
                         select new
                         {
                             date = (datetime)result.element(ns + "column0")),
                             kpi = (string)result.element(ns + "column1")),
                             value = (decimal)result.element(ns + "column2"))
                         });

score:0

returnvalue = (from rows in doc.root.descendants(ns + "row")
select (from columns in rows.elements() select object)columns.value).toarray()
).tolist();

More Query from same tag