Forum Discussion
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 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..
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..
3 Replies
v-sihou-msftMicrosoft Employee
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:
Regards,
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
Does the empty cells exist in key column? Or is that column involved in any calculation which can't allow BLANK()?
Regards,