Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
adrien5555
Helper II
Helper II

OLE DB or ODBC error DISP_E_TYPEMISMATCH

‎05-04-2016 08:36 AM

Hi All,

 

this error shows up when I try to refresh data.

 

The data source is a local csv :

 

test2.png

 

Config: windows 10

 

thanks for helping 🙂

Adrien

 

Labels:
Message 1 of 23
103,314 Views
1 ACCEPTED SOLUTION
austinsense
Impactful Individual
Impactful Individual
In response to adrien5555

‎05-09-2016 04:40 AM

The type mismatch is probably happening because you're doing some conversion from the orginial data types - go into the query editor and remove any type conversions and see if that works.

Austin is VP Operations at PowerPivotPro and a professional self-service enthusiast 🙂

View solution in original post

Message 3 of 23
115,035 Views
22 REPLIES 22
evang550
Employee
Employee
In response to adrien5555

‎05-26-2016 10:00 PM

Hi adrien - did you ever figure out why this was happening? And if there was a fix/work around? I'm having the same issue.

Message 7 of 23
84,480 Views
0
adrien5555
Helper II
Helper II
In response to evang550

‎05-27-2016 08:20 AM

Hi Evan,

 

Yes it worked for me. I had to remove all the applied steps (5 or 6) until the step 'changed type' which seemed to cause the error.

 

Since I re-created all the steps, the error never showed up again, so worth trying it!

Message 8 of 23
84,188 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.

View All