Project for the Web Power BI Template, exclude template projects from reporting

New Contributor

This must have been asked and answered but I just can't find it...

The great "Project for the Web Power BI Template" includes by default all the project form the portfolio. We have some labeled "Master: xxx" and flagged as favorites so the PMs can use them as templates, and do not have to start from scratch.

Is there a ways to simply exclude these from the reporting in the "Project for the Web Power BI Template" ?

thanx all

Petr  

1 Reply

Hello @Pet3Art ,

Yes you can do. Open the report in Power BI desktop and click Transform data. Expand the queries on the left hand side, in the Project for the web > Staging Queries folder click "Projects Staging". Scroll along the table until you see the column "msdyn_subject" and click the arrow on the column heading then click Text Filters. Select "Does not begin with" and enter "Master:" and click OK. You should now see the Master projects removed from the data set. Click Close & Apply.

Hope that helps

Paul