Forum Discussion
Unable to recognize the entry as a valid Excel document.
So friends, please I ask for your help, I have a dashboard that needs to be updated manually every day, so a third party program generates the files that I have to update in xml, so I place them in the correct folders and pbi updates the tables normally , that was until yesterday, today the error OLE DB OR ODBC [DATA FORMAT ERROR] Unable to consider the input as a valid Excel document is appearing. I tried everything, I redid the entire path of the table in M language, I deleted it and put it back, I opened the table and I didn't see any errors, I don't know what else to do
2 Replies
- Sahir_Maharaj
Super User
Hello dexx,
Can you please try the following steps that might help resolve the issue:
- Ensure the third-party program is indeed generating XML files and not inadvertently saving them in a format that's not compatible with Excel or Power BI. (Double-check if there have been any updates or changes in the third-party program's output format)
- Use Power Query's built-in XML import functionality to load your XML files. Power Query might offer more robust handling of XML structures and could bypass the issue you're facing.
Hope this helps!
friend it didn't work, can you help me? Here at the company, all the files and dashboards are in AWS, and whenever I try to update the dash this error appears, I have already checked the files individually and they are all correct, can the internet connection generate this error?
