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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors