Hi
My Team and I share a common pbix file that usually is worked upon across different desktops. I have recently normalized one dataset of 200+ columns in 10 different sheets simply by duplicating the main sheet into multiple sheets within powerquery and use 'choose column' feature to select the ones we wanted to retain for our normalized table and renaming that sheet in PowerBI transform.
We also created a custom column out of two other columns to create a primary key.
Problem is that once this file changed hands, replacing the datasource in a different teammate's computer went into error with.
Expression.Error: The key didn't match any rows in the table.
Details:
Key=
Item=mytablename
Kind=Sheet
Table=[Table]
I read at some forum, simply naming the sheet as mytablename would help, so I did that as well. However, now it fails to track the custom column created within powerquery and throws an error on that.
How do we solve this?
Thanks
