OLE DB or ODBC error: Exception from HRESULT: ox80040E1D

[eliele]

Hi,

I keep getting an OLE DB or ODBC error: Exception from HRESULT: ox80040E1D error message although the data does get refreshed in the query editor. 

When I refresh the data in the query editor everything works fine, but outside the query editor I get the message,

I haven't seen any working answer from previous Forums.

Thanks.

[Priti_Shah]

if Column type is changed in transform query..still this error persist?

[v-juanli-msft]

Hi @eliele

Please show me the information so that i can reproduce your problem.

1. which kind datasource, excel, sql ...?

2. which connection, import,direct query?

3. could you share the code in Advanced editor so that i can know what steps you applied?

Best Regards

Maggie

[eliele · Accepted solution]

Thank you for the response. 

I figured it out.

The error occurred when appending datasets with different data formats. The data I was querying had one date format and the already queried data had another.