Combine Multiple Files From SharePoint Folder

[mvabalaitis]

Hello All - 

When clicking "combine files" within the query editor to combine multiple Excel files from SharePoint the process gets stuck on "Evaulating Query" as shown in the screenshot below. PowerBI never reaches the combine binary screen as referenced in the link below. Has anyone ran into this issue and can advise a solution? I have verified my account has accessed to the SharePoint folder as I can open the files directly from SharePoint.

https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/