title: PowerBI: Check if the folder/directory we are loading to exists or not using Power Query
body: <p>I am a newbie in PowerBi and currently working on a POC where I need to load data from a folder or directory. Before this load, I need to check if<br>
  1) the respective folder exists 
  2) the file under the folder is with.csv extension.</p>
  
  <pre><code>Ex. Let suppose we have a file '/MyDoc2004/myAction.csv'.
  Here first we need to check if MyDoc2004 exists and then if myAction file is with.csv extension.
  </code></pre>
  
  <p>Is there any way we can do this using Power Query?</p>