SOLVED

Project for the Web

%3CLINGO-SUB%20id%3D%22lingo-sub-1528065%22%20slang%3D%22en-US%22%3EProject%20for%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528065%22%20slang%3D%22en-US%22%3E%3CP%3EHow%20do%20you%20close%20or%20archive%20a%20project%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBasically%20I%20do%20not%20want%20the%20project%20to%20be%20available%20in%20the%20web%20app%20or%20when%20using%20power%20bi%20or%20power%20apps.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529096%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20for%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529096%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%2F731375%22%20target%3D%22_blank%22%3E%40locious%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EYou%20could%20use%20the%20Deactivate%20option%20from%20the%20Model%20Driven%20interface%20then%20use%20the%20status%20code%20value%20to%20remove%20these%20projects%20from%20the%20Power%20BI%20Reports%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Deactivate.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206061iB5611639FAA0F6A3%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Deactivate.png%22%20alt%3D%22Deactivate.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThis%20updates%20the%20status%20for%20the%20project%2C%20you%20can%20use%20this%20to%20filter%20in%20reports%20etc.%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Deactive%20Data.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206062i2DEC80C53BE0A8FB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Deactive%20Data.png%22%20alt%3D%22Deactive%20Data.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20if%20that%20is%20an%20option%20for%20you.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529268%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20for%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529268%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F8793%22%20target%3D%22_blank%22%3E%40Paul%20Mather%3C%2FA%3E%26nbsp%3BThanks%20for%20your%20response.%20I'm%20new%20to%20project%2C%20power%20apps%20and%20power%20bi.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20able%20to%20deactivate%20the%20project%2C%20but%20i'm%20unable%20to%20find%20the%20filter%20to%20report%20on%20in%20power%20bi.%20Can%20you%20point%20me%20in%20the%20right%20direction%20here%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKeep%20in%20mind%20i'm%20using%20the%20CDS%20for%20my%20data%20source%20from%20Project%20for%20the%20web.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1529536%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20for%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1529536%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%2F731375%22%20target%3D%22_blank%22%3E%40locious%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EYou%20will%20need%20to%20open%20the%20Power%20BI%20Report%20in%20Power%20BI%20Desktop%20%26gt%3B%20Click%20Transform%20Data%20then%20in%20the%20query%20editor%20like%20below%20on%20the%20Projects%20Staging%20query%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22Filtered.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F206094iDAC188AA744CF174%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Filtered.png%22%20alt%3D%22Filtered.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3BThen%20click%20close%20and%20apply.%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531248%22%20slang%3D%22en-US%22%3ERe%3A%20Project%20for%20the%20Web%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531248%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F731375%22%20target%3D%22_blank%22%3E%40locious%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3EThis%20blog%20post%20might%20help%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fpwmather.wordpress.com%2F2020%2F07%2F18%2Fwhat-can-we-do-with-closed-archived-projects-in-project-for-the-web-projectfortheweb-msproject-msdyn365-ppm-office365-workmanagement-poweraddicts-nocode-powerplatform-powerbi%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpwmather.wordpress.com%2F2020%2F07%2F18%2Fwhat-can-we-do-with-closed-archived-projects-in-project-for-the-web-projectfortheweb-msproject-msdyn365-ppm-office365-workmanagement-poweraddicts-nocode-powerplatform-powerbi%2F%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

How do you close or archive a project? 

 

Basically I do not want the project to be available in the web app or when using power bi or power apps.

4 Replies
Highlighted

Hello @locious ,

You could use the Deactivate option from the Model Driven interface then use the status code value to remove these projects from the Power BI Reports:

Deactivate.png

 

This updates the status for the project, you can use this to filter in reports etc.:

Deactive Data.png

 

See if that is an option for you.

Paul

Highlighted

@Paul Mather Thanks for your response. I'm new to project, power apps and power bi. 

 

I was able to deactivate the project, but i'm unable to find the filter to report on in power bi. Can you point me in the right direction here?

 

Keep in mind i'm using the CDS for my data source from Project for the web.

 

Thanks

Highlighted

Hello @locious ,

You will need to open the Power BI Report in Power BI Desktop > Click Transform Data then in the query editor like below on the Projects Staging query:

Filtered.png

 Then click close and apply.

Paul

Highlighted
Best Response confirmed by locious (Occasional Contributor)