title: Is it Possible to update SQL server data using Excel Power query?
body: <p>I just recently realise, while using Excel, it lacks on features for being able to update SQL server data through their worksheet.</p>
  
  <p>I have tried using Data-->From other sources--> SQL Server data; that works like a charm but as it has limited ability (View and only get the latest data but not update). </p>
  
  <p>I don’t know if this is done purposely by Microsoft as a money making schemes. 
  But through my research today, I also came across PowerQuery, and It seems to do pretty much what Data add-in did escape it has few new extra features and sounds pretty advance, therefore, I was wondering if this add-in has the ability to update SQL server data using excel sheet, if so can you guys advise me to the right direction:</p>
  
  <p>I came across lots of commercials products that did the job but frankly speaking, I cannot afford it.</p>