Sie befinden sich hier: start » en » Internal Documentation » WvdS Data-Gateway » 3. User » 1. Excel » 1.2 Filter and Sort

Inhaltsverzeichnis

1.2 Filter and Sort

Filter data during import.

In Power Query Editor

After connecting:

  1. Choose Transform instead of Load
  2. Apply filters to columns
  3. Remove/rename columns
  4. Close and Load

Advantages

  • Only required data is transferred
  • Faster import for large tables
  • Filter is preserved during refresh

URL Parameters

Alternatively in the URL: 

http://server:5000/odata/demo/Customers?$filter=Country eq 'Germany'&$top=100
Zuletzt geändert: on 2026/01/29 at 11:22 PM

Seiten-Werkzeuge