stack depth limit exceeded

Hi TaariqMegaC 

The "stack depth limit exceeded" issue in PostgreSQL typically happens when a query involves too much recursion or overly complex operations that exceed PostgreSQL's memory stack limits(max_stack_depth parameter (default is 2MB)).

A few things we can check:

1. Recursive Logic – Does the table involve any recursive CTEs, circular references, or self-referencing joins?

2. Query Folding – Some Power Query transformations might generate inefficient SQL. Could you share the query steps applied to this table?

3. Data Model – Are there any loops in relationships between this table and others?

4. PostgreSQL Views/Functions – If the table relies on a view or function, we should verify its logic.

A quick fix might be simplifying the query or breaking it into smaller steps. If you can share:

• The table structure

• Any custom SQL or M-code used

• The transformations applied in Power Query