Forum Discussion
The input couldn't be recognized as a valid Excel document..
Data souce is excel files from sharepoint. My problem is auto refresh will got error "The input couldn't be recognized as a valid Excel document.. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action." if data source (excel file) modified by someone else. But auto refresh is working if all data source modified by me.
5 Replies
- lbendlinSuper User
xls or xlsx? Shared folder or sharepoint?
- rohaziFrequent Visitor
all files in xlsx format
- v-henryk-mstfCommunity Support
Hi rohazi ,
If I download an xlsx file locally, is it possible to connect and read the data properly?
Also, you can read related solution as below:
Solved: The input couldn't be recognized as a valid Excel ... - Microsoft Power BI Community
If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.