Forum Discussion
MrToast20
5 years agoFrequent Visitor
Get data from multiple excel files with multiple sheets
Hi there, Fairly new to PowerBI and looking for some help. I have around 60 excel files structured as follows: Filename: Apr 20 Sheets: 2017, 2018, 2019, 2020 Filename: Apr 19 Sheets: 20...
- 5 years ago
Hi MrToast20
All of this is possible using Power Query, please refer to this article to give you an example of how to do it
Regards
Phil
PhilipTreacy
Super User
5 years agoHi MrToast20
All of this is possible using Power Query, please refer to this article to give you an example of how to do it
Regards
Phil