We couldn't fold the expression to the data source. -> with REALLY simple query

[Wroclaw]

Hi All,

I'm getting an error We couldn't fold the expression to the data source. Please try a simpler expression. while trying to visualise very simple query, Basically I want to display one column in a table. I have 12 unique values spread across around 1200 rows. My source is Snowflake. In Dual mode it works fine, in DQ it fails.

M Code:

let
    Source = Snowflake.Databases(ServerParameter, WarehouseParameter, [Role=RoleParameter]),
    xyz= Source{[Name="xyz",Kind="xyz"]}[Data],
    xyz= xyz{[Name="xyz",Kind="Schema"]}[Data],
    xyz= xyz{[Name="xyz",Kind="Table"]}[Data],
    #"Renamed Columns" = Table.RenameColumns(xyz,{{"YEAR", "Year"}, {"MONTH", "Month"}, {"ACTUAL_DATE", "Date"}, {"DAY", "Day"}, {"LAST_DAY_OF_MONTH", "Last Day of Month"}, {"DAYNAME", "Dayname"}, {"YEAR_MONTH", "Year-Month"}, {"YEAR_MONTH_LONG", "Year-Month Long"}, {"YEAR_QUARTER", "Year-Quarter"}, {"QUARTER", "Quarter"}, {"MONTHNAME", "MonthName"}, {"MONTH_LONG", "Month Long"}, {"WEEK", "Week"}, {"DAY_LONG", "Day Long"}}),
    #"Filtered Rows" = Table.SelectRows(#"Renamed Columns", each [Date] >= #date(Date.Year(DateTime.LocalNow()) - 2, 1, 1) and [Date] <= #date(Date.Year(DateTime.LocalNow()), 12, 31))
in
    #"Filtered Rows"

Any idea what is causing that?

Thanks!

[Wroclaw · Accepted solution]

So I found it on my own. When I changed DQ to dual mode I changed the datatype from text to number. Then when I changed storage mode to DQ that setting was remembered and there was probably some type missmatch underhood.

[DataInsights]

@Wroclaw,

You could use custom SQL and do the column renaming and filtering in SQL: