title: POWER BI Refresh data source from Excel where file name changes daily
body: <p>I am building a report in Power BI of my company's daily figures. Those figures are published each morning in an excel file to our company server. I would change the scripts that build this file, but at the moment that's not an option.</p>
  
  <p>However, that file name has the date in it each day, so the filename CHANGES every day.</p>
  
  <p>Essentially I am trying to use an expression for the excel query to include the system date in the concatenated filename each morning.</p>