Using Direct Query with Snowflake connector, table visualization cannot display w/ boolean included

[Backer]

When using the connector to Snowflake with Direct Query, trying to add a boolean value that displays record-level detail (as opposed to aggregations) gives an error "Can't display the visual".  When clicking on the error it says:

Couldn't load the data for this visual

OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

For example, I get the error when building a 2 column table including ID (string) and IsClosed (boolean).

If I change the table to show an aggregation, for example summarize the ID to Count of ID (string) and IsClosed (boolean), the table visual works correctly.

Release:
February 2019

Product Version:
2.66.5376.2521 (19.02) (x64)

Error Message:
OLE DB or ODBC error: [Expression.Error] We couldn't fold the expression to the data source. Please try a simpler expression..

[v-qiuyu-msft]

Hi @Backer,

I would suggest you create a support ticket to get support. 

Best Regards,
Qiuyun Yu 

[AntoineAB]

Hello,
I have exactly the same problem.

Have you found any solution?

Thanks,

Antoine

[fbesse12]

Hi,

I also have the same issue.

To complete, when I publish my report on Power Bi Service it works fine, so I guess it's about connectors in Desktop but I can't figure it out.

Any solution since last post ?

Thanks,

François.

[fbesse12]

Hi contacted the support team and the issue if due to new June 2024 version.

I just rolled back to May version and it works fine !

François.

[AntoineAB1]

Hello François,

I solved my problem by creating a new string variable from the boolean while sourcing the data via native query ("SQL statement"), then transformed the variable back to boolean in Power BI.

Hope this helps!

Antoine