title: power query (M) create record from a text type column
body: <p>when retrieving data from a web based API into the Power BI, I did end up with a quoted record (text type) which I am unable to convert to a record. There must be a simple way to do this, unfortunately I was not able to find it.</p>
  
  <p>So simply <code>record = [A=1,B=2]</code> is implicitly detected, if written like this <code>record = "[A=1,B=2]"</code> you end up with a text, which needs to be converted. What function can do this kind of conversion?</p>
  
  <p>This is the result similar to the API, which will require transformation on the entire column.</p>
  
  <pre><code>let
      Source = {"[A=1, B=1, C=0, D=1]","[A=1, B=1, C=0, D=1]"},
      Table = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error)
  in
      Table
  </code></pre>