Combining multiple files from one folder is already supported built-in through the graphical interface of Power Query when use you Get Data from Folder. However, if you have one Excel file, with multiple sheets with the same structure but different data, you cannot use that option. There is a very little but useful trick that you can use to get data from multiple sheets dynamically rather than manually one by one from each sheet. This video is about that technique.
Learn more detailed steps, with links to study more, from my blog post here:
radacad.com/co...
Негізгі бет Combine Multiple or All Sheets from an Excel File into a Power BI solution Using Power Query Dynamic
Пікірлер: 41