Forum Discussion
Solved
API via PowerQuery - how to select only specific columns
Dear All, I am downloading data via Web from API from external data provider. The issue is, i would like: a. Recieve only specific columns, not all available b. To filter the columns via speci...
Thank You to all of You, it came out, that the api provider, doesn't have this functionalities...:(
Hi Wasowski
Maybe you can bring all columns into Power Query Editor first (this is just a data preview) then use Home > Choose Columns / Remove Columns to keep the specific columns you want.
After that, using Keep Rows / Remove Rows to filter rows. You can also click the down arrow on any column header to filter rows. If the filter condition is more complex, you can write M code to do that with Table.SelectRows.
The data will only be imported when you click on Apply button.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.