DAX query not working

Nov 22, 2016 at 4:35 PM
HI, is there a special trick to use for DAX query? I am using SQL Server 2016 and although an MDX query works, an equivalent DAX query using EVALUATE, returns the message:

Msg 6522, Level 16, State 1, Procedure ExecuteOLAP, Line 0 [Batch Start Line 0]
A .NET Framework error occurred during execution of user-defined routine or aggregate "ExecuteOLAP":
System.Exception: The result set returned by the server is not a cellset or a multidimensional data set.
System.Exception:
at OLAPExtensions.StoredProcedures.ExecuteOLAP(SqlString server, SqlString database, String MDX)

even though if I run the same EVALUATE query against the cube it returns a proper table. Is the SP checking for conforming column names or something else perhaps?