Filter data and then merge multiple excel files stored in a sharepoint

[Anonymous]

Hello everyone,

Thank you in advance for your help. I've an idea althought I dont know if it is possible.

We have a sharepoint list similar to this one in which each assigned analyst have to attach an excel document in astandarized manner in each row. Every row contains only 1 excel file and all of them have the same structure (Number of columns, names of the columns, etc).

Now I was able to Merge the files by using this helpful guide, but the problem is that I need to filter my sharepoint data BEFORE merging the files and by using this method it wont give me the option.

IE: Filter the data by "Argentina" Only and THEN merge all of the excel files.

Is there any workaround for this?

THANK YOU!!!

[V-lianl-msft]

Filtering after merging is a relatively simple method. You can apply the filter directly to the corresponding column after merging, or create a parameter to filter items.

https://www.poweredsolutions.co/2018/12/03/clever-filters-in-power-bi-power-query-with-merge-operati...