Forum Discussion

Frequent Visitor

5 years ago

Solved

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...

Need Help

PhilipTreacy
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

https://www.myonlinetraininghub.com/import-multiple-files-containing-multiple-sheets-with-power-query

Regards

Phil

PhilipTreacy

Super User

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

https://www.myonlinetraininghub.com/import-multiple-files-containing-multiple-sheets-with-power-query

Regards

Phil

Forum Discussion

Get data from multiple excel files with multiple sheets

Related content

MULTIPLE CARD

Multiple dataViewMappings

Merge data from multiple excel files from multiple sharepoint folders

Disable multiple eventstreams

Import multiple files with multiple sheets from folder