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
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... 

v-eqin-msft
Community Support
Community Support

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors