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.
Hi,
I have a single excel file with 50 tabs. Each tab represents some Server Silo Data. Each tab has the same 4 peices of data. I want to simply merge all the tabs into one large single table. And in the process only have one header, something alone the lines of a merge all tabs and remove the top row from all tabs except the first?
Any help would be appreciated.
Solved! Go to Solution.
1. Load in any 1 tab of your excel file
2. delete all the steps in the query editor except the first
3. Remove all columns except Data
4. In the Data column, click the Expand button. Uncheck the use origional name as prefix. Then click ok.
Hi sharpedogs,
Did you mean that you a Excel which have many sheets in it, and in each sheet, the header are all the same? If so, you could load all sheet in power bi , then use "Append Queries", then it will combine into one.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi sharpedogs,
Did you mean that you a Excel which have many sheets in it, and in each sheet, the header are all the same? If so, you could load all sheet in power bi , then use "Append Queries", then it will combine into one.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1. Load in any 1 tab of your excel file
2. delete all the steps in the query editor except the first
3. Remove all columns except Data
4. In the Data column, click the Expand button. Uncheck the use origional name as prefix. Then click ok.
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.