Unable to update source data from EXCEL files (PBI table)

Alfredo Izaguirre Castro 1 Reputation point
2020-07-24T16:18:12.23+00:00

When trying to update tables sourced from EXCEL data I got the following error message: OLE DB or ODBC error: Excepción de HRESULT: 0x80040E4E.

and it appears to affect the following tables to be updated because for them I got the message that "it wasnt possible to updat because of an error ocurred when trying to update other related table before"

I already checked source files name, table structure and everything reamians in the same condition as it was used for the first time when this PBI file was created, of course the data is different.

Can you help me with this?

Thanks in advance for your prompt answer as it is urgent to update reports and switch them over my users.

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,674 questions
{count} votes