raynok's avatar
raynok
Frequent Visitor
8 years ago
Status:
Accepted

Case expressions may only be nested to level 10.

Hi There and happy new year,   I've been running a report since 03-2017 with an "added conditional Column".It has 16 rows of conditions.   After applying the Dec 2017 update, I'm now receiv...
Reports
simontaylor's avatar
simontaylor
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

I upgraded to the latest version again and saw the error again:

 

DataSource.Error: Microsoft SQL: Case expressions may only be nested to level 10.
Incorrect syntax near '$Outer'.
Details:
    DataSourceKind=SQL
    DataSourcePath=wx1*****.database.windows.net,1433;********

   Message=Case expressions may only be nested to level 10.
Incorrect syntax near '$Outer'.
    Number=125
    Class=15

Completed Ideas