Error message when loading dataset: "The given key was not present in the dictionary."

Hi MacJasem 

Go back through the applied steps in your dataset transformation process. Pay special attention to any steps where you're filtering, merging, or performing operations that rely on key-value pairs. It's possible that a step might be referencing a column or key that no longer exists or was renamed.
Ensure that all the columns or keys used in your operations are correctly named and have the expected data type. A common cause for this error is when a column is expected but not found due to a typo or a change in the column name.
If your dataset involves merging or relating different tables or sources, verify that the relationships are correctly defined. An undefined or incorrect relationship can lead to this error if the key used to establish the relationship is missing.

Here are some links for your reference:

Solved: The given key was not present in the dictionary- P... - Microsoft Fabric Community

The given key was not present in the dictionary- PowerBI - Stack Overflow

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.