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 t...
Sahir_Maharaj
Super User
Super UserHello 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?
