A company is implementing advanced features for a Power Pages website. The company hosts documents and lists in several SharePoint environments that are hosted both on-premises and online. Users of…

Virtual tables expose external data as Dataverse entities but do not natively provide a federated search-and-filter experience spanning multiple disparate SharePoint environments.

SharePoint Server integration connects Power Pages to a single SharePoint environment and does not support simultaneously querying both on-premises and online SharePoint sources through one experience.

Power BI embedded is used to display analytics dashboards and reports within a Power Pages site and is not designed for viewing, searching, or filtering raw SharePoint document libraries or lists.

Progressive search is a Power Pages advanced feature that indexes and federates content from connected external sources, including SharePoint deployments across both on-premises and online hosting models. It presents results in a single, intuitive interface that supports viewing, searching, and filtering, which directly satisfies all requirements in the scenario.