Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Have you tried "Folder" as your data source? This should essentially append all of the files in the folder together into a single query.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |