Query a Dataset in Power Automate Not Returning Expected Results

I am trying to run a query against a dataset from PowerBI Semantic Model in Power Automate to return a CSV file with the outputs.

Steps I have taken:

1. Created a Power BI Desktop file that connects to a Power Bi dataflow as its source.
2. Created a visual of the fields I need to return.
3. Using Optimizer to record the refresh of the visual and get the DAX.
4. Used that DAX in the Power Automate flow to then create a CSV table.

The issue I am facing is the output is only about 23k rows - where the output of the visual is about 150k rows.

Below is the DAX I am using.

DEFINE
    VAR __DS0Core = 
        SUMMARIZE(
            'RIM Appended File',
            'RIM Appended File'[MATERIAL ID],
            'RIM Appended File'[CATALOG_NUMBER],
            'RIM Appended File'[CTRY ISO-CODE],
            'RIM Appended File'[COUNTRY],
            'RIM Appended File'[VALIDATE PRODUCT TYPE],
            'RIM Appended File'[VALIDATE LOCAL PRODUCT CLASS],
            'RIM Appended File'[VALIDATE REGISTRATION NUMBER],
            'RIM Appended File'[VALIDATE MFG_SITE],
            'RIM Appended File'[VALIDATE LEGAL_MFG],
            'RIM Appended File'[RIM File],
            'RIM Appended File'[SAP ID],
            'RIM Appended File'[Legacy ID],
            'RIM Appended File'[MAT ID],
            'RIM Appended File'[Division]
        )

EVALUATE
    __DS0Core

ORDER BY
    'RIM Appended File'[MATERIAL ID],
    'RIM Appended File'[CATALOG_NUMBER],
    'RIM Appended File'[CTRY ISO-CODE],
    'RIM Appended File'[COUNTRY],
    'RIM Appended File'[VALIDATE PRODUCT TYPE],
    'RIM Appended File'[VALIDATE LOCAL PRODUCT CLASS],
    'RIM Appended File'[VALIDATE REGISTRATION NUMBER],
    'RIM Appended File'[VALIDATE MFG_SITE],
    'RIM Appended File'[VALIDATE LEGAL_MFG],
    'RIM Appended File'[RIM File],
    'RIM Appended File'[SAP ID],
    'RIM Appended File'[Legacy ID],
    'RIM Appended File'[MAT ID],
    'RIM Appended File'[Division]

Snapshot of the flow: