Corrected Power Query

 

Corrected Power Query M Code

m
let
    Source = PowerBI.Dataflows(null),

    #"b3b252fb-a86d-4941-8358-0107921ebcb1" = Source{[workspaceId="b3b252fb-a86d-4941-8358-0107921ebcb1"]}[Data],

    #"cf83d579-195e-4623-9a18-a3e2de696486" = #"b3b252fb-a86d-4941-8358-0107921ebcb1"{[dataflowId="cf83d579-195e-4623-9a18-a3e2de696486"]}[Data],

    #"IFC TABLEAU DM SRM_CATALOG_V_GENEVA1" = #"cf83d579-195e-4623-9a18-a3e2de696486"{[entity="IFC_TABLEAU DM SRM_CATALOG_V_GENEVA"]}[Data],

    #"Removed Other Columns" = Table.SelectColumns(#"IFC TABLEAU DM SRM_CATALOG_V_GENEVA1", {"Catalog Item", "CIV - Catalog Item Variable", "RITM Number", "REQ Number", "CIV Value"}),

    #"Filtered Rows" = Table.SelectRows(#"Removed Other Columns",
        each 
        ([Catalog Item] = "IaaS Unix - Install v2" and [CIV - Catalog Item Variable] = "Operated For") or
        ([Catalog Item] = "IaaS Windows - Install v2" and [CIV - Catalog Item Variable] = "Operated For") or 
        ([Catalog Item] = "Physical Server Install" and [CIV - Catalog Item Variable] = "Operating For") or
        ([Catalog Item] = "Non IaaS VM-ADD" and [CIV - Catalog Item Variable] = "Operated For") or
        ([Catalog Item] = "DBaaS Database - Create Oracle" and [CIV - Catalog Item Variable] = "Line of Business") or
        ([Catalog Item] = "DBaaS Database - Create Oracle / Migrate Oracle" and [CIV - Catalog Item Variable] = "Line of Business") or 
        ([Catalog Item] = "DBaaS Database - Create PostgreSQL" and [CIV - Catalog Item Variable] = "Line of Business") or
        ([Catalog Item] = "JaaS Tomcat & WebSphere - Create" and [CIV - Catalog Item Variable] = "Network Zone") or
        ([Catalog Item] = "OS Rebuild" and [CIV - Catalog Item Variable] = "Operated For") or
        ([Catalog Item] = "IaaS Windows - Install v2" and [CIV - Catalog Item Variable] = "Region") or
        ([Catalog Item] = "JaaS Tomcat & WebSphere - Create" and [CIV - Catalog Item Variable] = "Implementation region") or
        ([Catalog Item] = "Non IaaS VM-ADD" and [CIV - Catalog Item Variable] = "Region") or
        ([Catalog Item] = "OS Rebuild" and [CIV - Catalog Item Variable] = "Region")
    )

in
    #"Filtered Rows"

---

Key Fixes

✔ Fixed incorrect workspace ID reference.
✔ Fixed incorrect dataflow ID reference.
✔ Fixed incorrect entity name reference.
✔ Fixed Table Select.Columns → Table.SelectColumns syntax.
✔ Fixed missing/extra brackets in filter conditions.
✔ Fixed incorrect - operator → replaced with =.
✔ Fixed extra spaces inside column references.