title: Power Bi nested list in string
body: <p>So i have the following problem:</p>
  <p>I'm trying to import some data from my database into my report.
  The data is provided by some views, which already have predetermined datatypes for my columns.
  Although they are not all correct. And here lies the problem.</p>
  <p>An example would be:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>items (type = int)</th>
  <th>itemDetails (type = string)</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>[[[Fruit], Fruit, Apple, 0.90]]</td>
  </tr>
  <tr>
  <td>2</td>
  <td>[[[Fruit], Fruit, Apple, 0.90],[[Veggie], Veggie, Salat, 1.50]]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>Now the problem is, that Power Bi doesn't recognize the data in the second column as a list, or an array.</p>
  <p>My goal is to extract the informations in these nested lists: so the desired output would be something like:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>items (type = int)</th>
  <th>itemDetails</th>
  <th>itemCategory</th>
  <th>itemName</th>
  <th>itemPrice</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>[[[Fruit], Fruit, Apple, 0.90]]</td>
  <td>Fruit</td>
  <td>Apple</td>
  <td>0.9</td>
  </tr>
  <tr>
  <td>2</td>
  <td>[[[Fruit], Fruit, Apple, 0.90],[[Veggie], Veggie, Salat, 1.50]]</td>
  <td>Fruit, Veggie</td>
  <td>Apple, Salat</td>
  <td>0.9, 1.5</td>
  </tr>
  </tbody>
  </table>
  </div>