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

%3CLINGO-SUB%20id%3D%22lingo-sub-2567628%22%20slang%3D%22en-US%22%3EProject%20for%20the%20Web%20Power%20BI%20Template%2C%20exclude%20template%20projects%20from%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2567628%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20must%20have%20been%20asked%20and%20answered%20but%20I%20just%20can't%20find%20it...%3C%2FP%3E%3CP%3EThe%20great%20%22Project%20for%20the%20Web%20Power%20BI%20Template%22%20includes%20by%20default%20all%20the%20project%20form%20the%20portfolio.%20We%20have%20some%20labeled%20%22Master%3A%20xxx%22%20and%20flagged%20as%20favorites%20so%20the%20PMs%20can%20use%20them%20as%20templates%2C%20and%20do%20not%20have%20to%20start%20from%20scratch.%3C%2FP%3E%3CP%3EIs%20there%20a%20ways%20to%20simply%20exclude%20these%20from%20the%20reporting%20in%20the%20%22Project%20for%20the%20Web%20Power%20BI%20Template%22%20%3F%3C%2FP%3E%3CP%3Ethanx%20all%3C%2FP%3E%3CP%3EPetr%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2567628%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EProject%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Ereporting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2569812%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20for%20the%20Web%20Power%20BI%20Template%2C%20exclude%20template%20projects%20from%20reporting%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2569812%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1108343%22%20target%3D%22_blank%22%3E%40Pet3Art%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EYes%20you%20can%20do.%20Open%20the%20report%20in%20Power%20BI%20desktop%20and%20click%20Transform%20data.%20Expand%20the%20queries%20on%20the%20left%20hand%20side%2C%20in%20the%20Project%20for%20the%20web%20%26gt%3B%20Staging%20Queries%20folder%20click%20%22Projects%20Staging%22.%20Scroll%20along%20the%20table%20until%20you%20see%20the%20column%20%22msdyn_subject%22%20and%20click%20the%20arrow%20on%20the%20column%20heading%20then%20click%20Text%20Filters.%20Select%20%22Does%20not%20begin%20with%22%20and%20enter%20%22%3CSPAN%3EMaster%3A%22%20and%20click%20OK.%20You%20should%20now%20see%20the%20Master%20projects%20removed%20from%20the%20data%20set.%20Click%20Close%20%26amp%3B%20Apply.%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EHope%20that%20helps%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%3CSPAN%3EPaul%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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