I actually pass this query to the same Datamart to populate a different table in my PowerPivot model:
SELECT
v_dim_wotask_ES.wotask_id
,v_dim_wotask_ES.work_order_cd
,v_dim_wotask_ES.task_cd
,v_dim_wotask_ES.work_order_desc
,v_dim_wotask_ES.task_desc
,v_dim_wotask_ES.wo_status_cd
,v_dim_wotask_ES.requested_date
,v_dim_wotask_ES.task_status_cd
,v_dim_wotask_ES.plant
,v_dim_wotask_ES.profit_center_cd
,v_dim_wotask_ES.cost_center_cd
,v_dim_wotask_ES.COORDER
,v_dim_wotask_ES.cost_type_cd
,v_dim_wotask_ES.bnft_par
,v_dim_wotask_ES.project_id
,v_dim_wotask_ES.powerplant_work_order_code
,v_dim_wotask_ES.business_analyst_text
,v_dim_wotask_ES.capital_groupings_text
,v_dim_wotask_ES.cost_recovery_capital_programs_text
FROM
v_dim_wotask_ES
WHERE
v_dim_wotask_ES.business_analyst_text = N'ES-EPM-Peurrung, Pam'
It returns 1,645 rows.