OLE DB or ODBC error: [Expression.Error] The key didn't match any rows.

[mjuamjua]

Hi, I have a problem with getting data from Sharepoint to Power BI. In sharepoint I have one folder, which contains two folders and inside the folders is one Excel file in each. In those Excel files, there is multiple sheets and I try to get one sheet per file. I managed to get the data to Power Query but when I try to download it to Power BI, the following problem occurs: OLE DB or ODBC error: [Expression.Error] The key didn't match any rows. Exception from HRESULT: 0x80040E4E. 

[Syndicate_Admin]

It's the same for me. I have two files in one folder on an SPO site. I can upload them to Power BI, everything works fine until I put a new file in the same folder on the SPO site. That's when the connection to the original files thunders and sends the error. Any suggestions? Best regards.