DataConnectors
DataConnectors copied to clipboard
DirectQueryCapabilities.From Output
Hello,
When a Table.View
handles DirectQueryCapabilities.From
using OnInvoke
, per https://github.com/microsoft/DataConnectors/issues/318#issuecomment-674159531, the method names in the table that's returned should be the methods that the view supports for folding when in Direct Query mode.
However, "supports for folding" can mean several different things:
- It could mean "supported for folding when invoked on the view" -- example:
Table.FirstN(myView, 100)
- It could mean "supported for folding when included in a
Table.SelectRows
expression" -- example:Table.SelectRows(myView, each List.Contains(someList, [value]))
- It could mean "supported for folding when included in a
Table.AddColumn
column expression -- example:Table.AddColumn(myView, "Total", List.Sum(someList))
- etc.
When handling DirectQueryCapabilities.From
using OnInvoke
, if I list a method in the table that's returned, am I promising that it will be supported:
- Everywhere it could be used with my view?
- Just that its use is supported in at least one of the places where it could be used with my view?
- Something else?
Thank you, Ben