cancel
Showing results for 
Search instead for 
Did you mean: 

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.

 

2018-01-08 09_52_25-.png

After applying the Dec 2017 update, I'm now receiving the following error and there isnt much I can find when trying to google the error except SQL referrences on correcting the syntax structure of nested case expressions in SQL. 

 

2018-01-08 09_56_09-MS ManagerV3_Inventory - Query Editor.png

 

I'm not sure how to fix this from myside. Our department relies on the report hourly. 

As I've mentioned its been working for 9 months and suddenly an error.

 

Hope its a easy fix?

 

Kind regards

Rayno

Status: Accepted
Comments
Frequent Visitor

Fix confirmed.

Frequent Visitor

It 🙂 looks like it is working, finially I can say goodbye to the November release and hello February. Looking forward. . .

 

Thank you Power BI Team. 

Member

I have just encountered this problem.