Forum Discussion
Data.Source Error - is this is a bug ??
I had to give it a try, and converted all the files with a Python script, took me some time but eventually I can refresh now my queries.
If Microsoft decided for some reasons to stop or to make obsolete the connection of .xls files in PQ through Excel, they should of communicate
Anyway now it works
This issue likely stems from how Power Query interprets file metadata or structure in the source. It's not necessarily a bug but may be due to inconsistencies in the file or data format. Try refreshing the preview, double-check the file's encoding or structure, and ensure the data source is stable.
thanks for your reply.
However as mentioned it worked for months and nothing has changed, if there was an issue with metadata it would not work from day 1 🙂