Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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.
You could use custom SQL and do the column renaming and filtering in SQL:
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
107 | |
88 | |
76 | |
67 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |