• 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.