Jul 16 2020 05:35 PM
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.
Jul 17 2020 06:27 AM
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:
This updates the status for the project, you can use this to filter in reports etc.:
See if that is an option for you.
Paul
Jul 17 2020 08:10 AM
@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
Jul 17 2020 09:48 AM
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:
Then click close and apply.
Paul
Jul 18 2020 01:20 PM
SolutionHi @locious ,
This blog post might help: https://pwmather.wordpress.com/2020/07/18/what-can-we-do-with-closed-archived-projects-in-project-fo...
Paul
Jul 18 2020 01:20 PM
SolutionHi @locious ,
This blog post might help: https://pwmather.wordpress.com/2020/07/18/what-can-we-do-with-closed-archived-projects-in-project-fo...
Paul