Ranking Queries in Data Source View/Reporting Model

I want to take advantage of the new SQL rank queries in my Data Source View - but it only gives me access to Tables and Views. Of course Views cannot handle one of these queries. Also, Named Queries are limited to view syntax.

So, is there anyway I can expose such a query to my Report Model Or can I do something similar in my Report Model

e.g
 
WITH QCS
AS
(
  SELECT Field1, SUM(Field2) AA TotalF1
  FROM vwTable
  GROUP BY Field1
) 
SELECT *, RANK() OVER (ORDER BY TotalF1) AS Rank
FROM QCS