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'm trying to combine the data from quite a Excel files with identical columns.
Every file has just a single worksheet. But, sometimes it's called 'Sheet1', and sometimes it's something else entirely. The ones that aren't 'Sheet1' are throwing errors.
I'm thinking there must be some simple workaround for this, just I don't know it...?
Here I've pressed to expand the content, and it shows me the dialogue for the first sheet (where the worksheet is indeed named Sheet1).
Solved! Go to Solution.
Nevermind got it - see in the screenshot in my original post, just right click the folder (that in my screenshot says 'Sample File paramater5', then select the only option (edit). That will pull everything into a table (regardless of sheet name), and let you work from there.
Nevermind got it - see in the screenshot in my original post, just right click the folder (that in my screenshot says 'Sample File paramater5', then select the only option (edit). That will pull everything into a table (regardless of sheet name), and let you work from there.
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 |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |