DataConnectors icon indicating copy to clipboard operation
DataConnectors copied to clipboard

DirectQueryCapabilities.From Output

Open bgribaudo opened this issue 2 years ago • 2 comments

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

bgribaudo avatar Jan 10 '22 18:01 bgribaudo