Home
%3CLINGO-SUB%20id%3D%22lingo-sub-362068%22%20slang%3D%22en-US%22%3EA%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-362068%22%20slang%3D%22en-US%22%3E%0A%20%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CSTRONG%3EFirst%20published%20on%20TECHNET%20on%20Oct%2026%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3E%20***%20Update%2011%2F3%20-%20non-English%20installation%3F%26nbsp%3B%20scroll%20down%20to%20Raphael's%20comment%20where%20you%20will%20find%20some%20tips%20on%20getting%20this%20working%20***%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20We%20are%20pleased%20to%20announce%20the%20release%20of%20a%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI.%20Starting%20October%2026%202017%2C%20Project%20Online%20users%20will%20be%20able%20to%20download%20the%20new%20content%20pack%20directly%20from%20AppSource%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CA%20href%3D%22https%3A%2F%2Fapp.powerbi.com%2Fgroups%2Fme%2Fgetdata%2Fservices%2Fproject-online%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20https%3A%2F%2Fapp.powerbi.com%2Fgroups%2Fme%2Fgetdata%2Fservices%2Fproject-online%20%3C%2FA%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Comprising%20of%2013%20visually%20rich%20report%20pages%2C%20the%20new%20content%20pack%20is%20designed%20to%20support%20the%20management%20needs%20of%20project%20managers%2C%20portfolio%20managers%20and%20resource%20managers%2C%20by%20retrieving%20planning%20and%20execution%20data%20from%20Project%20Online%20and%20arranging%20the%20data%20to%20support%20timely%20decision%20making.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20The%20new%20content%20pack%20report%20includes%20reports%20in%20three%20key%20perspectives%3A%20Individual%20Projects%2C%20Portfolio%20of%20projects%20and%20the%20organization%E2%80%99s%20resources.%20Each%20perspective%20encompasses%20the%20following%20detailed%20report%20pages.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3EIndividual%20Projects%20%3C%2FB%3E%20%3CB%3E%20%E2%80%93%20%3C%2FB%3E%20This%20perspective%20includes%202%20report%20pages%20presenting%20information%20of%20a%20single%20project%20at%20a%20time%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Project%20Status%20%E2%80%93%20%3C%2FB%3E%20A%20summary%20of%20a%20selected%20project%20including%20work%20and%20cost%2C%20over%20time%2C%20upcoming%20milestones%20and%20overall%20status.%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F85733iE91A016D220440CC%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Project%20Risks%20and%20Issues%20%E2%80%93%20%3C%2FB%3E%20Issues%20and%20risks%20for%20a%20selected%20project.%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F85734iE8725E8AC229087E%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3EPortfolio%20of%20Projects%20%3C%2FB%3E%20%3CB%3E%20%E2%80%93%20%3C%2FB%3E%20This%20perspective%20includes%206%20report%20pages%20offering%20multiple%20analysis%20angles%20on%20portfolio%20of%20projects%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Portfolio%20Dashboard%20%3C%2FB%3E%20%3CB%3E%20%E2%80%93%20%3C%2FB%3E%20At%20a%20glance%20summary%20of%20all%20your%20projects%2C%20including%20completion%20status%20and%20performance%20KPIs.%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F85735iA5F17B4DBBFA6636%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Portfolio%20Timeline%20%E2%80%93%20%3C%2FB%3E%20An%20interactive%20timeline%20of%20projects%20in%20the%20portfolio%2C%20their%20planned%20start%20and%20finish%20dates%20as%20well%20as%20completion%20data.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Portfolio%20Costs%20%E2%80%93%20%3C%2FB%3E%20A%20detailed%20report%20of%20the%20portfolio%20costs%2C%20with%20details%20on%20cost%20status%20for%20specific%20projects.%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F85736i342E39209BF47DC9%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Portfolio%20Milestones%20%E2%80%93%20%3C%2FB%3E%20Key%20milestones%20in%20the%20portfolio%20and%20their%20statuses.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Portfolio%20Risks%20%E2%80%93%20%3C%2FB%3E%20Aggregated%20risks%20across%20the%20portfolio%20and%20their%20impact%20on%20the%20portfolio.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Portfolio%20Issues%20%E2%80%93%20%3C%2FB%3E%20Aggregated%20issues%20across%20the%20portfolio%20and%20the%20causes%20for%20those%20issues.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3EResource%20%3C%2FB%3E%20%3CB%3E%20%E2%80%93%20%3C%2FB%3E%20This%20perspective%20includes%205%20report%20pages%3A%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Resource%20Availability%20-%20%3C%2FB%3E%20Availability%20and%20demand%20for%20resources%20over%20time%2C%20presented%20through%20interactive%20heatmap%20and%20charts.%20%3CBR%20%2F%3E%20%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F85737i7BDC81B54C156A77%22%20%2F%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Resource%20Overview%20%E2%80%93%20%3C%2FB%3E%20A%20view%20of%20all%20the%20resources%20in%20the%20portfolio%20and%20their%20detailed%20information.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Resource%20Assignments%20%E2%80%93%20%3C%2FB%3E%20Deeper%20view%20into%20how%20resources%20are%20invested%20across%20the%20different%20projects%20in%20the%20portfolio%2C%20with%20information%20on%20their%20progress%20in%20current%20assignments.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Resource%20Details%20%E2%80%93%20%3C%2FB%3E%20A%20summary%20of%20a%20selected%20resource%20including%20availability%2C%20assignments%20and%20work%20over%20time.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%C2%B7%20%3CB%3E%20Resource%20Demand%20Forecast%20%E2%80%93%20%3C%2FB%3E%20Forecast%20of%20demand%20for%20resource%20in%20upcoming%20time%20periods%2C%20based%20on%20current%20plans%20and%20predictive%20analytics.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3EHow%20to%20set%20up%20the%20Content%20Pack%20%3C%2FB%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Go%20to%20this%20%3CA%20href%3D%22https%3A%2F%2Fpowerbi.microsoft.com%2Fen-us%2Fdocumentation%2Fpowerbi-content-pack-project-online%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20Power%20BI%20site%20%3C%2FA%3E%20to%20learn%20how%20to%20set%20up%20the%20Content%20Pack.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3EFAQs%20%3C%2FB%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3E%20Where%20can%20I%20find%20the%20new%20Content%20Pack%3F%20%3C%2FB%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20The%20new%20Content%20Pack%20is%20available%20for%20download%2C%20directly%20from%20Power%20BI%20through%20%E2%80%98Get%20Data%E2%80%99.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20The%20Content%20Pack%20is%20also%20available%20on%20%3CA%20href%3D%22https%3A%2F%2Fapp.powerbi.com%2Fgroups%2Fme%2Fgetdata%2Fservices%2Fproject-online%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20AppSource%20%3C%2FA%3E%20and%20a%20PBIT%20file%20is%20shared%20through%20%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-Power-BI-Content-Packs%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3E%20GitHub%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20%3CB%3EWill%20the%20new%20content%20pack%20replace%20the%20previous%20Project%20Online%20Content%20Pack%3F%20%3C%2FB%3E%20%3CBR%20%2F%3E%20%3CBR%20%2F%3E%20Yes%2C%20the%20new%20content%20pack%20replaces%20the%20previous%20Project%20Online%20Content%20Pack.%20The%20new%20Content%20Pack%20offers%20a%20larger%20number%20of%20reports%20and%20leverages%20latest%20Power%20BI%20capabilities%2C%20for%20a%20richer%20analysis%20experience.%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-362068%22%20slang%3D%22en-US%22%3EFirst%20published%20on%20TECHNET%20on%20Oct%2026%2C%202017%20***%20Update%2011%2F3%20-%20non-English%20installation%3F%26nbsp%3B%20scroll%20down%20to%20Raphael's%20comment%20where%20you%20will%20find%20some%20tips%20on%20getting%20this%20working%20***We%20are%20pleased%20to%20announce%20the%20release%20of%20a%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI.%3C%2FLINGO-TEASER%3E%3CLINGO-SUB%20id%3D%22lingo-sub-691171%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-691171%22%20slang%3D%22en-US%22%3E%3CP%3EThis%20content%20pack%20for%20Project%20Online%20is%20terrific.%20I%20do%20have%20one%20question%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20received%20a%20request%20to%20add%20an%20overall%20filter%20that%20only%20shows%20Projects%20that%20are%20active%2C%20not%20those%20that%20are%20100%25%20complete.%20It%20seems%20that%20the%20%22edit%22%20functions%20are%20disabled.%20Is%20that%20the%20case%20-%20customizing%20to%20fit%20our%20needs%20is%20not%20possible%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%20-%20and%20nice%20work%20in%20putting%20this%20together!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-692024%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-692024%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%0A%3CP%3EIf%20you%20download%20the%20Power%20BI%20template%20file%20from%20GitHub%20you%20can%20then%20open%20that%20in%20Power%20BI%20Desktop%20and%20edit%20this%20as%20required.%20Here%20is%20a%20link%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-Power-BI-Content-Packs%2Fblob%2Fmaster%2FMicrosoft%2520Project%2520Online%2520Power%2520BI%2520Content%2520Pack.pbit%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FOfficeDev%2FProject-Power-BI-Content-Packs%2Fblob%2Fmaster%2FMicrosoft%2520Project%2520Online%2520Power%2520BI%2520Content%2520Pack.pbit%3C%2FA%3E%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708029%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708029%22%20slang%3D%22en-US%22%3E%3CP%3EPaul%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20reply%20and%20link%2C%20it%20was%20exactly%20what%20I%20needed.%20I've%20downloaded%20the%20file%2C%20opened%20it%20in%20BI%20Desktop%20and%20I%20can%20edit%20as%20needed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CEM%3EIf%20I%20can%20ask%20one%20more%20question%3A%3C%2FEM%3E%3C%2FP%3E%3CP%3EOn%20the%20Portfolio%20Dashboard%20there%20are%20three%20stoplight%20KPIs%20for%20%3CSTRONG%3ECost%20Health%3C%2FSTRONG%3E%2C%20%3CSTRONG%3EWork%20Health%3C%2FSTRONG%3E%20and%20%3CSTRONG%3ESchedule%20health%3C%2FSTRONG%3E.%20Our%20PMO%20is%20asking%20what%20the%20thresholds%20are%20that%20would%20affect%20the%20colors%20of%20the%20stoplights.%20I've%20dug%20around%20the%20properties%20of%20those%20and%20could%20not%20determine%20the%20answer.%20Can%20you%20tell%20me%20how%20these%20are%20configured%20so%20I%20can%20provide%20that%20answer%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708475%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708475%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359968%22%20target%3D%22_blank%22%3E%40Pandra%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThose%20are%20calculated%20based%20default%20fields%2C%20for%20example%20the%20Cost%20Health%20field%20just%20replaces%20the%20string%20value%20of%20the%20CKPI%20field%20with%20the%20correct%20image%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119791i733AFDF128CAF4FD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PowerBICostHealth.jpg%22%20title%3D%22PowerBICostHealth.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20CKPI%20field%20just%20calculates%20of%20default%20fields%20such%20as%20Project%20Baseline%20Cost%2C%20Project%20Baseline%20Finish%2C%20Project%20Cost%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F119792iAA496F6551E25DA5%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22PowerBICKPI.jpg%22%20title%3D%22PowerBICKPI.jpg%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EThe%20Work%20one%20use%20the%20work%20fields%20and%20schedule%20uses%20the%20duration%20fields%20instead%20of%20the%20cost%20fields.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20easily%20change%20these%20%2F%20add%20your%20own.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHope%20that%20helps%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPaul%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-708542%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-708542%22%20slang%3D%22en-US%22%3E%3CP%3EIt%20does%20help%2C%20thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20screenshots%20you%20provided%20also%20help%20a%20lot.%20For%20example%2C%20the%20code%20behind%20the%20Work%20Health%20one%20tells%20me%20that%20if%20the%20baseline%20is%20at%20least%2020%25%20over%20baseline%20cost%2C%20indicate%20that%20with%20a%20specific%20color.%20(And%20so%20on%20for%20other%20baseline%20info)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20look%20deeper%20into%20the%20others%20it%20will%20tell%20a%20similar%20story%20of%20the%20logic%20behind%20which%20color%20is%20displayed.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESuper%20helpful%20and%20greatly%20appreciated%20-%20thanks%20again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-763451%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-763451%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Paul%2C%3C%2FP%3E%3CP%3ENeed%20to%20ask%20you%20a%20question%3A%20The%20Project%20Status%20tab%20seems%20to%20lose%20the%20data%20after%20scheduled%20refreshes%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F123690i038404AE4B89FA7E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Power%20BI%20refresh%20issue.PNG%22%20title%3D%22Power%20BI%20refresh%20issue.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20tried%20to%20refresh%20it%20manually%20and%20each%20time%20the%20Project%20Status%20tab%20shows%20blanks%20across%20the%20board.%20All%20other%20tabs%20work%20and%20refresh%20fine.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20idea%20why%2C%20or%20suggestions%20to%20resolve%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-776054%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-776054%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F359968%22%20target%3D%22_blank%22%3E%40Pandra%3C%2FA%3E%26nbsp%3B-%20What%20have%20you%20changed%20in%20this%20report%20page%3F%20Does%20the%20underlying%20data%20connection%20show%20the%20raw%20data%20in%20Power%20BI%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-777663%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-777663%22%20slang%3D%22en-US%22%3E%3CP%3EPaul%2C%20thank%20you%20for%20the%20reply.%3C%2FP%3E%3CP%3EThis%20one%20turned%20out%20to%20be%20a%20user%20error%20-%20the%20report%20in%20the%20dashboard%20is%20actually%20working%20fine.%3C%2FP%3E%3CP%3EThanks....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-813866%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-813866%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20facing%20issue%20with%20Project%20filter%20available%20on%20Risk%20and%20issue%20report%26nbsp%3B%3C%2FP%3E%3CP%3Ewhen%20I%20select%20a%20project%20from%20slicer%20both%20the%20grids%20(%20risk%20and%20issues)!goes%20blank%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20I%20choose%20project%20name%20from%20risk%20or%20issues%20table%20and%20create%20a%20slicer%20then%20it%E2%80%99s%20able%20to%20filter%20respective%20individual%20grid!%3C%2FP%3E%3CP%3Eanybody%20facing%20similar%20issues%20or%20know%20solutions%3F%20Please%20help%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-814340%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-814340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F395497%22%20target%3D%22_blank%22%3E%40Jayant440%3C%2FA%3E%26nbsp%3Bhello%2C%20on%20the%20default%20Microsoft%20Report%20pack%20this%20works%20fine%20for%20me.%20The%20only%20reason%20I%20can%20think%20of%20is%20that%20the%20relationships%20have%20been%20changed%20in%20your%20report%3F%20Here%20are%20the%20defaults%20for%20Issues%20and%20Risks%3A%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-left%22%20style%3D%22width%3A%20968px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F127749i9FA93AD64D9B2A43%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22IssuesandRisks.png%22%20title%3D%22IssuesandRisks.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816360%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816360%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%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%3EThanks%20for%20your%20reply%20%2C%20I%20haven't%20changed%20anything%20in%20the%20report%2C%20I%20also%20checked%20the%20relationships%20are%20intact%2C%20only%20thing%20I%20changed%20is%20the%20url%20to%20connect%20to%20our%20PWA%20instance%2C%20not%20sure%20then%20why%20its%20not%20working%20for%20me!%20anything%20that%20I%20can%20provide%20you%20which%20will%20help%20you%20to%20figure%20out%20whats%20the%20issue%3F%20Thanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-816378%22%20slang%3D%22en-US%22%3ERe%3A%20A%20new%20Project%20Online%20Content%20Pack%20for%20Power%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-816378%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%3Eits%20working%2C%20I%20think%20I%20was%20doing%20something%20wrong%2C%20Thanks%20for%20your%20reply.%3C%2FP%3E%3C%2FLINGO-BODY%3E
First published on TECHNET on Oct 26, 2017
*** Update 11/3 - non-English installation?  scroll down to Raphael's comment where you will find some tips on getting this working ***

We are pleased to announce the release of a new Project Online Content Pack for Power BI. Starting October 26 2017, Project Online users will be able to download the new content pack directly from AppSource:

https://app.powerbi.com/groups/me/getdata/services/project-online

Comprising of 13 visually rich report pages, the new content pack is designed to support the management needs of project managers, portfolio managers and resource managers, by retrieving planning and execution data from Project Online and arranging the data to support timely decision making.

The new content pack report includes reports in three key perspectives: Individual Projects, Portfolio of projects and the organization’s resources. Each perspective encompasses the following detailed report pages.

Individual Projects This perspective includes 2 report pages presenting information of a single project at a time:

· Project Status – A summary of a selected project including work and cost, over time, upcoming milestones and overall status.


· Project Risks and Issues – Issues and risks for a selected project.


Portfolio of Projects This perspective includes 6 report pages offering multiple analysis angles on portfolio of projects:

· Portfolio Dashboard At a glance summary of all your projects, including completion status and performance KPIs.


· Portfolio Timeline – An interactive timeline of projects in the portfolio, their planned start and finish dates as well as completion data.

· Portfolio Costs – A detailed report of the portfolio costs, with details on cost status for specific projects.


· Portfolio Milestones – Key milestones in the portfolio and their statuses.

· Portfolio Risks – Aggregated risks across the portfolio and their impact on the portfolio.

· Portfolio Issues – Aggregated issues across the portfolio and the causes for those issues.

Resource This perspective includes 5 report pages:

· Resource Availability - Availability and demand for resources over time, presented through interactive heatmap and charts.


· Resource Overview – A view of all the resources in the portfolio and their detailed information.

· Resource Assignments – Deeper view into how resources are invested across the different projects in the portfolio, with information on their progress in current assignments.

· Resource Details – A summary of a selected resource including availability, assignments and work over time.

· Resource Demand Forecast – Forecast of demand for resource in upcoming time periods, based on current plans and predictive analytics.

How to set up the Content Pack

Go to this Power BI site to learn how to set up the Content Pack.

FAQs

Where can I find the new Content Pack?

The new Content Pack is available for download, directly from Power BI through ‘Get Data’.

The Content Pack is also available on AppSource and a PBIT file is shared through GitHub .

Will the new content pack replace the previous Project Online Content Pack?

Yes, the new content pack replaces the previous Project Online Content Pack. The new Content Pack offers a larger number of reports and leverages latest Power BI capabilities, for a richer analysis experience.
12 Comments
Regular Visitor

This content pack for Project Online is terrific. I do have one question:

 

I received a request to add an overall filter that only shows Projects that are active, not those that are 100% complete. It seems that the "edit" functions are disabled. Is that the case - customizing to fit our needs is not possible?

 

Thanks in advance - and nice work in putting this together!

Hello,

If you download the Power BI template file from GitHub you can then open that in Power BI Desktop and edit this as required. Here is a link: https://github.com/OfficeDev/Project-Power-BI-Content-Packs/blob/master/Microsoft%20Project%20Online...

Paul

Regular Visitor

Paul,

 

Thank you for the reply and link, it was exactly what I needed. I've downloaded the file, opened it in BI Desktop and I can edit as needed.

 

If I can ask one more question:

On the Portfolio Dashboard there are three stoplight KPIs for Cost Health, Work Health and Schedule health. Our PMO is asking what the thresholds are that would affect the colors of the stoplights. I've dug around the properties of those and could not determine the answer. Can you tell me how these are configured so I can provide that answer?

 

Thank you!

 

@Pandra 

Those are calculated based default fields, for example the Cost Health field just replaces the string value of the CKPI field with the correct image:PowerBICostHealth.jpg

 

The CKPI field just calculates of default fields such as Project Baseline Cost, Project Baseline Finish, Project Cost:

PowerBICKPI.jpg

The Work one use the work fields and schedule uses the duration fields instead of the cost fields.

 

You can easily change these / add your own.

 

Hope that helps

 

Paul

Regular Visitor

It does help, thank you.

 

The screenshots you provided also help a lot. For example, the code behind the Work Health one tells me that if the baseline is at least 20% over baseline cost, indicate that with a specific color. (And so on for other baseline info)

 

If I look deeper into the others it will tell a similar story of the logic behind which color is displayed. 

 

Super helpful and greatly appreciated - thanks again!

Regular Visitor

Hello Paul,

Need to ask you a question: The Project Status tab seems to lose the data after scheduled refreshes:

 

Power BI refresh issue.PNG

 

I have tried to refresh it manually and each time the Project Status tab shows blanks across the board. All other tabs work and refresh fine.

 

Any idea why, or suggestions to resolve this?

 

Thank you in advance...

 

@Pandra - What have you changed in this report page? Does the underlying data connection show the raw data in Power BI?

Regular Visitor

Paul, thank you for the reply.

This one turned out to be a user error - the report in the dashboard is actually working fine.

Thanks....

 

Occasional Visitor

I am facing issue with Project filter available on Risk and issue report 

when I select a project from slicer both the grids ( risk and issues)!goes blank 

if I choose project name from risk or issues table and create a slicer then it’s able to filter respective individual grid!

anybody facing similar issues or know solutions? Please help

@Jayant440 hello, on the default Microsoft Report pack this works fine for me. The only reason I can think of is that the relationships have been changed in your report? Here are the defaults for Issues and Risks:

IssuesandRisks.png

Occasional Visitor

Hi @Paul Mather Thanks for your reply , I haven't changed anything in the report, I also checked the relationships are intact, only thing I changed is the url to connect to our PWA instance, not sure then why its not working for me! anything that I can provide you which will help you to figure out whats the issue? Thanks.

Occasional Visitor

@Paul Matherits working, I think I was doing something wrong, Thanks for your reply.