Processing error: The key didn't match any rows in the table.

[SSorenson]

Good Afternoon,

I have been trying to publish my dataset from PowerBI Desktop but when it uploads, it doesn't refresh properly. My end goal is to publish this dataset to PowerBI online and have it update everyday through Google Analytics. I think Google Analytics might be the problem here but I'm not sure why. Here is the error in its entirety:

Processing error: The key didn't match any rows in the table.
Cluster URI: WABI-US-EAST2-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 7ce139dc-4793-4dd9-a0c9-6ec741303ffc
Request ID: c7a11f83-b8a1-77e5-ef5d-34538df78d4a
Time: 2022-05-11 19:23:24Z

Any help here would be greatly appreciated.

Sam

[amitchandak · Accepted solution]

@SSorenson , This error comes when the column which is coming from the source is not matching the one here. In the Change type or rename step

Check is there any change in column name or some addition/ removal