Hi all,
Working through what mentioned above.
The missing piece here is that the KIND="Table" not "View"
By default if you are creating off a view in Denodo you will see that the KIND="View"
You can't apply a Table function to a view.
So the solution is to edit this and convert this to "Table"
let
Source = Denodo.Contents("SERVER=dap-test.had.sa.gov.au;PORT=9996;DATABASE=dap_cae01", null, [Timeout=#duration(0,0,4,0)]),
dap_cae01_Database = Source{[Name="dap_cae01",Kind="Database"]}[Data],
dap_cae01_Schema = dap_cae01_Database{[Name="dap_cae01",Kind="Schema"]}[Data],
rpt_times_out_everytime_parameter_Table = dap_cae01_Schema{[Name="rpt_times_out_everytime_parameter",Kind="Table"]}[Data],
rpt_my_output = Table.SelectRows(rpt_times_out_everytime_parameter_Table, each [whereclause] = pWhereClause )
in
rpt_my_output
In this view I'm creating a generic where clause I want to be able to change at runtime to force a time out for testing just incase you are wondering about the context.
Hope this helps.
Nick
