Power BI - Get Data - SQL Server Direct Query Issue with MAXDOP

[powerbiuser2024]

Hi, I am trying to Get Data from a SQL Server and am having an issue with my direct query.

Data Connectivity Mode:  DirectQuery

SQL Statement includes --> MAXDOP of 1

Tail end of my SQL Query that contains the error:

Error Message when getting data to power bi:

Does anyone know if there is a way to get this query to work with the MAXDOP in my query?

[lbendlin]

are you concerned about overwhelming your SQL server?

can you show the rest of the Power Query code?