Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I want to Get Excel Files from a Folder without Combining it to one table
I want to get each Sheet from the Workbooks as a Tables Seperatly
is there any
Hi, @Abdelrhman_2020
Based on your description, I'd like to suggest your create a function in Power Query as below.
(Path as text,ExcelName as text,SheetName as text)=>
let
Source = Folder.Files(Path),
PathStep = Source{[#"Folder Path"=Path,Name=ExcelName]}[Content],
#"Imported Excel" = Excel.Workbook(PathStep),
SheetStep = #"Imported Excel"{[Item=SheetName,Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(SheetStep, [PromoteAllScalars=true])
in
#"Promoted Headers"
You may input a set of parameters and get a a corresponding query. After executing multiple times, you can get tables what you want.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your Reply
What should I fill in the Excel Name and Sheet Name
as i have a Several Excel Workbooks in my Folder and I have a lot of Sheets in it
If they are a few, you can read and add them one by one
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
56 |
User | Count |
---|---|
99 | |
92 | |
84 | |
74 | |
66 |