Forum Discussion
Combine Excel Files in a Folder by Sheet
Hello everyone,
I'm wondering if it is possible to combine excel files in a folder by sheet. I have 12 similar excel files in a folder, but i want to combine each sheet in a table.
| Folder | File1 | Sheet1.1 | Sheet1.2 | Sheet1.3 |
| File2 | Sheet2.1 | Sheet2.2 | Sheet2.3 | |
| File3 | Sheet3.1 | Sheet3.2 | Sheet3.3 | |
| Table 1 | Table 2 | Table 3 |
The last 3 tables should be my results. Is it possible to do that? Thank you for your help!
2 Replies
Hi, Anonymous
Sorry for the late reply. I have spent some time on researching and figuring out how to reach your expected results.
Unfortunately, it seems that Power BI currently does not support such function.
In this case, you can submitt your idea here:https://ideas.powerbi.com/forums/265200-power-bi-ideas/filters/top
What is Idea?http://aboutpowerbi.com/index.php/2018/09/11/power-bi-ideas/
Best regards,
Paul Zheng