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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

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


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:





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,

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?






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:

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!


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.







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.




Helpful resources

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.