I have been using SharePoint folders to store an Excel file in to use for Power BI. I have recently received another Excel sheet within the folders and I am getting this error message:
"An error occurred in the ‘Transform File’ query. Expression.Error: The key didn't match any rows in the table.
I have looked online for solutions, some saying that I need to make sure the file names are the same (SharePoint won't let me do this). I have had a look at both files and all columns are the same also. I am unsure what else to do, can someone please advise!