Consolidate data for creating visualization

[asafra]

I have data in Excel sheets 10 in the same file. Every file are the following: customer name, ID cards, monthly income customer. Some of the names of the customers overlap.  I'm looking for a way to consolidate all data and manage them using the POWER BI

[v-haibl-msft]

@asafra

Do you mean that there are multiple sheets in one excel file like below?

If that is the case, you can get data from this excel file and select all sheets you want to import.

Then append all these tables using the Append Queries function.

If there are duplicate records, just remove duplicates.

Best Regards,

Herbert

[Greg_Deckler]

Have you tried "Folder" as your data source? This should essentially append all of the files in the folder together into a single query.