Here is the code. The error I got is
Expression.Error: We cannot convert a value of type Record to type Text.
Details:
Value=[Record]
Type=[Type]
I am trying to create a dynamic query where i can use a filter in the PowerBI UI to determine what dates i am returning from snowflake. Thanks!
let
selectedDates = if Type.Is(Value.Type(DateMParameter), List.Type) then
Text.Combine({"'", Text.Combine(DateMParameter, "','") , "'"})
else
Text.Combine({"'" , DateMParameter , "'"}),
selectAllCountries = if Type.Is(Value.Type(DateMParameter), List.Type) then
List.Contains(DateMParameter, "__SelectAll__")
else
false,
query = "SELECT #(lf)*#(lf)#(lf)FROM LANDING.HIDDEN.POWERBIPROJECTSUMMARY",
dynamicFilter = if selectAllDates then " "
else Text.Combine({" WHERE Date in(", selectedDate, ")"}),
finalQuery = Text.Combine({query, dynamicFilter}),
Source = Value.NativeQuery(Snowflake.Databases("HIDDEN.southeast-asia.azure.snowflakecomputing.com","POWERBI_WH"){[Name="LANDING"]}[Data], [Query=finalQuery], null, [EnableFolding=true])
in
Source
