Project Online - Business Drivers matrix table in Power BI

Hi! After classifying our ongoing projects we could get to this matrix table in Project Online: There are 6 Business Drivers where each project contributes on a rating scale (None, Low, Moderat...

Business Intelligence

Online

Brass Contributor

Jun 06, 2025

The function worked like this, taking into account there is only one analysis done, so all projects have the same AnalysisId:

let
    GetSelectedFieldsForEachProject = (ProjectId as text) =>
        let
            url = "https://mycompany.sharepoint.com/sites/pwa/_api/ProjectData/PortfolioAnalysisProjects(AnalysisId=guid'4734f66d-b33f-f011-b02b-00155d7c9042',ProjectId=guid'" & ProjectId & "')/Analysis",
            result = OData.Feed(url, null, [Implementation = "2.0"]),
            selectedFields = Record.SelectFields(result, {"PrioritizationId", "AnalysisName", "CreatedDate"})
        in
            selectedFields
in
    GetSelectedFieldsForEachProject

The following are the five tables with all private company data removed:

https://1drv.ms/x/c/82e81f538612a159/EYUzGHmjzQJOiIh0tmXiKe4BeclO5873PXywIFOjFGiu6A?e=jC61bV

https://1drv.ms/x/c/82e81f538612a159/ES6U63BJnkxDoFQ22oCEagwB3MHHGqULpasnd59HM06zVQ?e=lk4wEm

https://1drv.ms/x/c/82e81f538612a159/EXsY3tuEL6NHhgwl2q1yJTkBmwwSdA9LhHHiaPCtmF1ndw?e=v1bWUK

https://1drv.ms/x/c/82e81f538612a159/EVreqh2jAw1Jp6f3KpcUUj4BKkknPJq-g3NmUZ2H6fVTmg?e=4g5Lmx

https://1drv.ms/x/c/82e81f538612a159/ETiSJCziIPVPnk_owthsW3gB_j5JNgXiebng5t_c7HWFUA?e=YcY60f

I am not able to find the relationship between each Project, the Impact Level and the Business Driver to create that matrix table. I believe there is no connection.

RodFromm

Iron Contributor

Jun 06, 2025

Based on your spreadsheets the relationships appear to be present, but they don't let you access the table/fields that contains the Business Driver values: Extreme, Low, Strong, etc. Wish I could offer additional suggestions, but we do not have this feature enabled.

Woody
Brass Contributor
Jun 06, 2025
Appreciate you taking a shot at it 👏

Forum Discussion

Project Online - Business Drivers matrix table in Power BI

Resources