Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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?


Community Support
Community Support

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. 

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors