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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
adrien5555
Helper II
Helper II

OLE DB or ODBC error DISP_E_TYPEMISMATCH

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

 

1 ACCEPTED SOLUTION

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

22 REPLIES 22

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.

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!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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