Forum Discussion

cagataysahin's avatar
cagataysahin
Regular Visitor
9 years ago
Solved

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

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 sam...
Need Help
  • cagataysahin's avatar
    cagataysahin
    9 years ago

    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.. 

cagataysahin's avatar
cagataysahin
Regular Visitor
9 years ago

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's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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,