Forum Discussion
Solved
Trying to combine Multiple Excel files from SharePoint on PowerBI
I followed the tutorial from https://powerbi.microsoft.com/fr-fr/blog/combining-excel-files-hosted-on-a-sharepoint-folder/ The excel files have 4 rows empty before the headers - So I tried two ...
Okay, so I was able to combine them all correctly but I do not have the data source yet! I've tried the same process on Excel. The problem is when I try to apply the query it takes probably 2 hours to try and load all the rows, and it seems to load them twice. then I get an error saying im not connected anymore and that my credentials are invalid but they arent. I am just trying to combine them all and be able to use them. But they are just stuck in power query ?