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
anili
Frequent Visitor

OLE DB or ODBC error: While Refreshing all my reports both from Service and Desktop

Hi,

We have same dashboard format for multiple projects and all are in different workspaces. All of their data are coming from different sharepoint folders that are set for the specific project. 

When we tried to refresh our dashboards this month, almost all of the dashboards gave the same error which I couldn't figure out what it might be. 

 

Please see below:

 

anili_0-1680585910996.png

 

 

OLE DB or ODBC error: Type mismatch. (Exception from HRESULT: 0x80020005 (DISP_E_TYPEMISMATCH)).

 

Anyone has any idea why this might be caused?

Best regards,
Anil

4 REPLIES 4
DRibeiro18
New Member

I got the same error after last update and I don't know what to do. This is a super important dashboard to my function and we release it to other departments yesterday and now I cannot update with new information from Excel database.

 

I tried to change the unique columns that shown some kind of error in Power Query editor and nothing seems to work.

 

I saw some people saying to replicate these columns and erase the originals and rename the new ones to the same name but I don't understand how this gonna work since I closed the dashboard in Tuesday and when I opened on Wed, it no longer worked anymore.

 

Please, can anyone help with this matter?

 

DRibeiro18_0-1684001238947.png

 

DRibeiro18_1-1684001831226.png

 

AlexanderPrime
Solution Supplier
Solution Supplier

Sounds like one of the types in your data sources has changed and your report query can't convert it to your report's format. (Or someone's put the wrong format of data in a column somewhere, if you are pulling from an excel file on sharepoint this can be easy to do). 

Recommend opening up Power Query and checking the "Changed Type" steps in it, failing that, check your data sources to see if someone's put the wrong type of information in your sharepoint files, such as putting text in a date column, etc. 

More info: https://community.powerbi.com/t5/Desktop/OLE-DB-or-ODBC-error-DISP-E-TYPEMISMATCH/m-p/33267/highligh...


Please note - I am not affiliated with Microsoft, I'm just an end user like yourself.
Just a regular guy doin' Data Science.

If my post has helped you, please don't forget to thumbs up or click "Accept as solution" if it solved your problem!

Hey!


I took a look in all columns and there was just two showing error and it got fixed but the error still remains. I'm freaking out, dude.

 

I changed two columns' type and quality changed to valid, so the error is not happening anymore but when I try to update, the error is shown again.

DRibeiro18_0-1684011597197.png

 

DRibeiro18_1-1684011763734.png

 

DRibeiro18_2-1684011787029.png

 

Investigating here, I discover that this problem is in 'Prazo Fornecedor' column cause when I go to transform data and remove all data showing error, PBI update from database correctly. But with this removal, all essential data are gone, this breaks up my dashboard. Definitely, I don't know what to do... The problem is: Even when I fixed the data types and quality is not showing any error, Power BI does not update properly, just when I removed all incorrect data.

 

DRibeiro18_0-1684086997278.png

 

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.