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
wrwillits
Helper III
Helper III

Model Refresh not finding Column Headers and breaking

I have a couple models that have been working fine up until th November update. The models have been pulling data from tables whose structures (column headers) have not changed since the origial development (only the data is being updated). What's happening now, though, is if I run a refresh the process will break because it states it can't find a specific column header title. The problem is, though, that when I go back into Power Query and see what's going on with the tables, the column headers that PowerBI states are not there, are actually there. I don't understand what is going on here and my only thought is that something changed at the Novemver update that has caused the issue because the models will refresh if I use the September release of PowerBI. Can anyone help me on this? 

M codeM codeColumn Header that the Error Notice is pointing toColumn Header that the Error Notice is pointing toError NoticeError Notice

2 ACCEPTED SOLUTIONS
HotChilli
Super User
Super User

Slightly different case of the 'stateFIPS' v 'StateFIPS'?

 

View solution in original post

Wow, I should have picked that up! Leave it to the CDC to slighty change how they are reporting their data.

 

Thanks

View solution in original post

2 REPLIES 2
HotChilli
Super User
Super User

Slightly different case of the 'stateFIPS' v 'StateFIPS'?

 

Wow, I should have picked that up! Leave it to the CDC to slighty change how they are reporting their data.

 

Thanks

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.