title: Install dplyr package in R for MS SQL server 2016
body: <p>How to install a particular R package dplyr  on SQL Server 2016. How we can install this package on SQL Server 2016.</p>
  
  <p>I am trying to install dplyr on server side :</p>
  
  <pre><code>lib.SQL&lt;-"C:\\Program Files\\Microsoft SQL Server\\MSSQL13.MSSQLSERVER2016\\R_SERVICES\\library"
  install.packages("dplyr",lib=lib.SQL)
  </code></pre>
  
  <p>Its getting installed.
  But while loading</p>
  
  <pre><code>library("dplyr")
  </code></pre>
  
  <p>Its throwing error , library not found</p>
  
  <p><a href="https://i.stack.imgur.com/guzAK.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/guzAK.png" alt="enter image description here"></a></p>
  
  <p><a href="https://www.red-gate.com/simple-talk/sql/bi/using-r-package-within-sql-server-real-time-analysis-power-bi/" rel="nofollow noreferrer">I followed this link</a></p>
  
  <p>after installing i was still getting error while loading dplyr package.</p>