CODEWITHSUNDEEP
filterpowerquery
Umut K
Umut K

Reputation: 1388

power query - how to use a filtered list of an sql query

i have an sql query which selects a list of data.

but i want to use this data after filtering it in excel table (not in power query)

i tried to create another "query from table" but it takes all the data, not the filtered one.

Example File

any ideas ?

Upvotes: 2

Views: 397

Answers (1)

MarcelBeug
MarcelBeug

Reputation: 2997

If you filter the table in Excel, it will only hide the rows that do not meet the selection criteria, it will not delete the rows.

In order to get a filtered table, you can create a separate table with filter criteria and use that to create a filtered table, either by using Advanced Filtering in Excel, or by using Power Query.

In this video I illustrate how to do it with Advanced Filtering.

Upvotes: 2

Related Questions