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...
I have the same problem. I am able to copy old queries from a few months ago, and they work fine to combine my list of 9 Excel files into one table, even if I use a Sharepoint Folder as the source. The issue seems to be in actually using the "combine files" button, which is somehow failing to recognize that Excel files are indeed Excel files, and so it refuses to create the transformation sample file, and associated function and parameter.