Project Online - Business Drivers matrix table in Power BI

Try this and see if you can extract the PrioritizationId from the Analysis record.  I don't have this functionality enable in my PWA so you may have to fiddle with it a bit to make it work.

Steps to Create and Use the fxGetPrioritizationIdByAnalysisId Function

1. Create the Function Query
   • In Power Query, create a new blank query.
   • Name it fxGetPrioritizationIdByAnalysisId.
2. Add the Function Code
   • Copy and paste the provided code into the fxGetPrioritizationIdByAnalysisId query.
3. Apply the Function in Your Data
   • Go to the PortfolioAnalysisProjects query.
   • Click Add Column > Invoke Custom Function.
4. Configure the Function Invocation
   • Set the new column name to: PrioritizationID.
   • Choose the function query: fxGetPrioritizationIdByAnalysisId.
   • For the parameter, select the AnalysisId column.
5. Finish
   • Click OK to apply the function and generate the new column

let
    GetSelectedFieldsFromAnalysis = (analysisId as text) =>
        let
            url = "https://<your PWA URL>/_api/ProjectData/PortfolioAnalysisProjects('" & analysisId & "')/Analysis",
            result = OData.Feed(url, null, [Implementation = "2.0"]),
            record = result{0},
            selectedFields = Record.SelectFields(record, {"PrioritizationID", "AnalysisName", "CreatedDate"})  // Add more fields as needed
        in
            selectedFields
in
    GetSelectedFieldsFromAnalysis