title: Importing data from .xls files when gettimg data from a folder in power query
body: <p>I have tried to get data from a particular folder containing only .xls using power query without any luck. Right now I'm running a macro to save as .xlsx before refreshing the data, however, I'd like to reduce that step and get data without having to change the format.</p>
  <p>Can anyone help me with the same?</p>