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: 

Vote for your favorite vizzies from the Power BI Dataviz World Championship submissions. Vote now!

Andyrice1989

Snowflake boolean columns no longer working in new PBI version 2.130.754.0

Submitted by on ‎06-12-2024 04:34 AM

Since the latest upgrade none of our boolean columns work in power BI. We're using direct query and snowflake. 

Andyrice1989_0-1718191767021.png

 

Has anyone else encountered this? is there a workaround or fix as it has impacted a large number of our reports.

 

Thanks

 

Status: Accepted
See more ideas labeled with:
6 Comments (6 New)
Comments
Anonymous
Not applicable
‎06-13-2024 02:24 AM

Hi @Andyrice1989 ,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best regards.
Community Support Team_Caitlyn

Andyrice1989
Regular Visitor
‎06-23-2024 11:50 PM

Hi Guys,

 

Any update on this please?

 

Thanks

slitewka
New Member
‎03-17-2025 05:53 AM
Hello, Could you please advise what is the status? It generates huge troubles in our project.
JessieF
Advocate II
Advocate II
‎03-18-2025 10:44 AM
Is there an official support ticket or support blog posting to follow on this topic? We are also anxiously awaiting an update to avoid data type changes in our warehouse.
roberto_monesi
New Member
‎05-01-2025 02:11 AM
Is there any update on this? We are still having issues when trying to loading boolean value from snowflake into powerBI. The only way to make it working with custom queries is to convert all boolean into strings, that certainly is not sustainable nor good practice?
A_Groemling
New Member
‎05-21-2025 06:47 AM
Hi @roberto_monesi, we have encountered the same problem and found out that this problem only occurs if you use the [Implementation = “2.0”] flag in the "Source" step in Power Query. After we removed this, it works for us. You can enable/disable this feature in the preview functions. File > Options and Settings > Options > Preview features > Use new Snowflake connector implementation More info here: https://learn.microsoft.com/en-us/power-query/connectors/snowflake
Idea Statuses