Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ShekharKr
Frequent Visitor

Getting error in Power BI: SQL compilation error: In-list contains more than 50 non-constant values

My backend data base is Snowflake and we have a direct query connection with Power BI. 

 

Some of my visulas are giving the below mentioned error suddenly. 

 

There is one visual level filter (using measure)  applied on this visual, which is  - # No of Employees > 0. (When I am removing this filter, I am not getting the error. But with this filter I am getting the error)

The measure is - count(# No of Employees = Table[Employee_Key]).

 

SQL compilation error: In-list contains more than 50 non-constant values: COLLATE_TO_BINARY('Headquarters LDB', 'en-ci'),COLLATE_TO_BINARY('DEG L''Oreal UK', 'en-ci'),COLLATE_TO_BINARY('DPP Chile', 'en-ci'),...

 

What can be done differently to solve this issue.

1 ACCEPTED SOLUTION
rajendraongole1
Super User
Super User

Hi @ShekharKr - we will see these errors indicates that the SQL query generated by Power BI is exceeding Snowflake's limit for the number of non-constant values allowed in an IN clause.Instead of filtering at the visual level, try aggregating the data first like preaggregate the employee count.

 

later you can implement Row-Level Security to filter data at the data model level rather than at the visual level. This can help reduce the amount of data that needs to be processed by the visual and avoid hitting the Snowflake limit.

Simplify or adjust the logic of your filter to reduce the number of unique values.

 

Hope it helps.

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

1 REPLY 1
rajendraongole1
Super User
Super User

Hi @ShekharKr - we will see these errors indicates that the SQL query generated by Power BI is exceeding Snowflake's limit for the number of non-constant values allowed in an IN clause.Instead of filtering at the visual level, try aggregating the data first like preaggregate the employee count.

 

later you can implement Row-Level Security to filter data at the data model level rather than at the visual level. This can help reduce the amount of data that needs to be processed by the visual and avoid hitting the Snowflake limit.

Simplify or adjust the logic of your filter to reduce the number of unique values.

 

Hope it helps.

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.