Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

raynok

Case expressions may only be nested to level 10.

Submitted by on ‎01-08-2018 12:16 AM

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
See more ideas labeled with:
33 Comments (33 New)
Comments
simontaylor
Employee
Employee
‎02-06-2018 10:46 AM

Fix confirmed.

raynok
Frequent Visitor
‎02-07-2018 12:44 AM

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. 

bullius
Helper V
Helper V
‎05-30-2018 06:50 AM

I have just encountered this problem.

 

 

Idea Statuses