Forum Discussion

Helper III

9 years ago

Solved

Combine Multiple Excel Workbooks in Power Query

Hi, I want to combine multiple excel woorkbooks that located on SharePoint in Power Query For example : 1. file 1 2. file 2 3. file 3 I need to see all the files in power query (...

Need Help

Phil_Seamark
9 years ago
Hi Recoba88

Does this blog help?

https://blog.crossjoin.co.uk/2016/09/19/loading-data-from-multiple-excel-workbooks-into-power-bi-and-making-sure-data-refresh-works-after-publishing/

Phil_Seamark

Microsoft Employee

9 years ago

Hi Recoba88

Does this blog help?

https://blog.crossjoin.co.uk/2016/09/19/loading-data-from-multiple-excel-workbooks-into-power-bi-and-making-sure-data-refresh-works-after-publishing/

Recoba88

Helper III

9 years ago

It worked, but it didn't bing all the files unfortunately, I get an error

May you help me with this issue?

Forum Discussion

Combine Multiple Excel Workbooks in Power Query

Related content

Combine multiple excel workbook with multiple sheets

Power Query Combine Multiple Files From Folder

Tables combine

Combine values from multiple rows

How to load multiple excel workbooks each with multiple worksheets?