Forum Discussion

Einomi's avatar
Einomi
Helper V
1 year ago
Solved

Data.Source Error - is this is a bug ??

Hi,   I have a folder in OneDrive for Business that I use as a source in PQ. Every week, I get 4 .xls reports into that folder via Power Automate. I open my Excel, hit Refresh and everything comes...
  • Einomi's avatar
    1 year ago

    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