Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Cocobabe89
Regular Visitor

Issues while opening powerquery for shared pbix

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

1 REPLY 1
amitchandak
Super User
Super User

@Cocobabe89 , This error happens when the column names are changed in Excel or the names of sheets change.  Users can add new, but if they rename, it need an update

 

Also consider dataflow, if the same code is used at multiple places

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.