Skip to main content
Microsoft Idea

Power BI

Needs Votes

Make getting data from a folder containing Excel workbooks simple

Vote (1) Share
rhetset's profile image

rhetset on 19 Jun 2019 23:20:17

I am an instructor who teaches students to use Power BI. There is often a need to import multiple Excel workbooks from a folder, but the fact that Power BI does not automatically or programmatically combine the Excel workbooks that have the same structure without throwing one error or another is quite shocking to me.

Currently, the only method that works is adding a column containing =Excel.CurrentWorbkook([Content]) and expanding/combining, but I would sure think Power BI could do that for the user without the user having to mess with all those steps.