In SSRS, not all query types are supported by all data sources. For example, Table is supported only by data source types OLE DB and ODBC. So please check your data source type.

Please see:

http://msdn.microsoft.com/en-us/library/ms178261.aspx

http://msdn.microsoft.com/en-us/library/cc281378.aspx