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 3 excel, would like to load this from a folder into power BI, how do i load this without combining, so that it gets loaded as 3 differnt tables in power BI
IPO TMT 2013-Aug 2018.xlsx
|
Solved! Go to Solution.
Hi @vjnvinod,
There is no direct way to load multiple files from a single folder as separate queries without combing into desktop.
You may need to load the three excel files one by one into desktop. Alternatively, as a workaround, you can load them together then split the single table into three tables via duplicating and filtering. For details, please see: Splitting a table into two based on column value
Best regards,
Yuliana Gu
Hi @vjnvinod,
There is no direct way to load multiple files from a single folder as separate queries without combing into desktop.
You may need to load the three excel files one by one into desktop. Alternatively, as a workaround, you can load them together then split the single table into three tables via duplicating and filtering. For details, please see: Splitting a table into two based on column value
Best regards,
Yuliana Gu
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 |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |