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: 

Data Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more

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
Regular Visitor
‎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