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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Error: Detected type mismatches

Hi, I have added two columns to my excel file. one at the begining as the first column and the other one in the midddle. Now, my dashboard does not refresh and getting following errors in query. Can someone help pls? I dont know how to fix the error. 

shivaghafuri_0-1657175369491.pngshivaghafuri_1-1657175404886.png

 

3 REPLIES 3
Anonymous
Not applicable

The error message is regarding a data in one of columns. seems becuase i added 2 new columns, the data in one of my previous columns is messed up... 

Anonymous
Not applicable

Hi @Anonymous ,

 

It seems that "Detected type mismatches" is the step name not the full error message ,right?

Could you please provide the error messages or share the error screeshots to help us clarify your scenario?

 

Best Regards,
Eyelyn Qin

Anonymous
Not applicable

You might want to go through each column and reselect data type instead of "kept errors" since your measures/added columns might depend on the data type to run correctly. 

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.