Support Wildcards in OPENROWSET for SharePoint-Backed OneLake Shortcuts

[jasonhorner]

Support Wildcards in OPENROWSET for SharePoint-Backed OneLake Shortcuts

Summary
OPENROWSET does not support wildcard paths when querying files via OneLake shortcuts pointing to SharePoint/OneDrive, even though the same syntax works for native OneLake / ADLS paths.

Current Behavior
Wildcard patterns (e.g. *.csv) fail when the underlying path is a SharePoint shortcut because the engine attempts a directory listing that SharePoint shortcuts do not expose.

SELECT *
FROM OPENROWSET(
  BULK 'abfss://<workspace>@onelake.dfs.fabric.microsoft.com/<lakehouse>/Files/sp-shortcut/data_*.csv',
  FORMAT = 'CSV'
) AS r;

Msg 13807: Content of directory cannot be listed

Expected Behavior

• Wildcard expansion should work for SharePoint/OneDrive shortcuts, consistent with native OneLake and ADLS behavior.

Impact

• Users cannot query partitioned or multi-file datasets stored in SharePoint via shortcuts.

• Forces manual file enumeration or data duplication into native OneLake storage.