Forum Discussion
Power Query error 'The key didn't match any rows in the table.' when combining
Hello everyone, I'm trying to merge multiple excel files into one spreadsheet using Power Query, but I receive the following error when doing so: An error occurred in the ‘Transform File’ query. ...
Hello, I'm having the following problem: I want to update the data in Excel (Data --> Query and Connections). I then receive the following error message: "DataFormat.Error: We received a misformatted web response from https://eonos.sharepoint.com:443/sites/PlaToNPlanungundReporting-PuR-Arbeitsdateien2/Shared%20Documents/PuR%20-%20Arbeitsdateien/PlaToN%20GuV%20aktuelle%20Daten/Datenbasis%20Anl%C3%A4sse.xlsb." The problem isn't with the file or the link, as my colleagues can update it.