Forum Discussion
Combine Files button does not work for valid Excel files in Power BI
Hi, I have a SharePoint folder with two Excel files called 'File 1.xlsx' and 'File 2.xlsx'. The folder contains no other files of any type, and it contains no hidden files. In Power BI, w...
Please see this video with another way to combine your files. It will at least help you troubleshoot a little more (e.g., by adding a custom column with the Excel.Workbook function to explore the binary content).
How to Create and Modify Custom Functions in Power BI (or Excel) - YouTube
Pat
Thank you so much for sharing that video! Watched it entirely and it's a great technique to simplify the query window.