/ dt / FactInternetSale / WHERE DimCurrency.AlternateKey EQ 'USD' / PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount / Limit

Limit

[ROOT]  dt  FactInternetSale  WHERE DimCurrency.AlternateKey EQ 'USD'  WHERE DimCurrency.AlternateKey EQ 'USD'   PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount   

ERROR:

Query expression

Limit

failed to parse with the following error response:

errorResponses:
Not two words like 'LIMIT {limit}' but 1 words.
Syntax:
Syntax: LIMIT {limit} like 'LIMIT 42'

Last query expression to successfully parse was 'PIVOT DimCustomer.Name+','+DimCustomerId BY OrderDate.Year() SUM SalesAmount'.

(NOTE. After the first valid QueryExpression, all following items in the request must also be valid query expressions)

Generated 2025-12-21 07:38:24.327 UTC