While loading some data from several Excel files into Power BI, I encountered the following errors:
Table1: “Load was cancelled by an error in loading a previous table.”
Table2: “OLE DB or ODBC error: [Expression.Error] The key didn’t match any rows in the table.”
Table3: “A single value for column ‘Area of Responsibility’ in table ‘Requisitions-Load’ cannot be determined. This can happen when a measure formula refers to a column that contains many values without specifying an aggregation such as min, max, count, or sum to get a single result.”
As you know (since you are reading this post), these error messages are not very specific. I did not immediately find anything obviously wrong. After reading a couple posts, I checked the latest data files to see if there were any new, missing, or incorrect column names or sheet names.
Turns out, one of the files did not have the expected Sheet name. After updating the sheet name to the correct name, all the files loaded without an issue.
I got the following error after adding multiple new fields to a Workday report.
“Found a duplicate sort descriptor for Field”
Turns out the solution was simple. There was a field that was inadvertently added twice in the “Sort” tab.
After removing one of the duplicates, the error was resolved. So, if you get this error, just check if you have a field listed twice in your Sort tab, confirm your comparison, and then remove one of them.
Good luck!
Information and resources for the data professionals' community
The Data Community 