Data refresh: OLE DB or ODBC error: Exception from HRESULT: 0x80040E1D

[cagataysahin]

Hi ,

I have an error that I mentioned in subject. I tried to solve that but I couldnot.

I changed the type of possible reason of that error columns that inclueds dates but it has still exact same problem.

I changed also different columns to different types but it also gives same error type.

Is there any solution that I could use to solve that problem ? I could not refresh my datas and it cause difficulties that I create again and again different dashboards... 

Here the photo of that error ;

Thanks..

[v-sihou-msft]

@cagataysahin

What's the data type of that "issue" column? It seems you build relationships between tables, make sure the "link" columns are same data type.

Does it only occur when refreshing data? If so, please verify your connection. See a similar thread below:

https://community.powerbi.com/t5/Desktop/Dates-disappear-when-Refreshing-data-in-Power-BI-Desktop/td...

Regards,

[cagataysahin · Accepted solution]

Hi,

@v-sihou-msft , I solved that problem created new table without any N/A cells and it seems good but if I add the N/A cell or blank cell, I get the same problem. I think its the problem that microsoft should solve that. Because for instance If I have table which includes some blank cells.. What should I do ? 

Thanks for now.. 

[v-sihou-msft]

@cagataysahin

Does the empty cells exist in key column? Or is that column involved in any calculation which can't allow BLANK()?

See: BLANK Handling in DAX

Regards,