title: R code to modify strings in column not working in Power BI/Query
body: <p>I have a query that combines multiple excel files and final step looks like this:</p>
  
  <pre><code>     = Table.TransformColumnTypes(#"Expanded Table Column1",{{"Source.Name", type text}, 
          {"Column1", Int64.Type}, {"Date", type date}, {"Path", type text}, 
          {"AstType", type text}, {"AstName", type text}, {"SYMBOL", type text}, 
          {"ISO", type text}, {"MValue", type number}, {"Weight", type number}, 
          {"#Sec", Int64.Type}, {"Flag", Int64.Type}, {"RunDate", type date}})
  </code></pre>
  
  <p>Now I am trying to run some R code:</p>
  
  <pre><code>dataset$Path = gsub('A Fund.', '', dataset$Path)
  dataset$Path = gsub('Fund.', '', dataset$Path)
  </code></pre>
  
  <p>But this is returning an empty table. I am always ignoring the Privacy level settings. How can this be fixed?</p>