title: Using BigQuery repeated / nested fields in Power BI
body: <p><strong>Problem:</strong> When connecting Power BI to a BigQuery table (using the native BQ connector) with repeated / nested fields, these fields do not appear in Power BI for use in report creation.</p>
  
  <p><strong>Example:</strong> Using a Public BigQuery data set called bigquery-public-data:samples, there is a table called github_nested which has repeated fields such as payload.pages.action (see below)</p>
  
  <p><a href="https://i.stack.imgur.com/wazFs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/wazFs.png" alt="BigQuery repeated / nested fields"></a></p>
  
  <p>However, when connecting to this BigQuery table using Power BI I only get a handful of fields (see below)</p>
  
  <p><a href="https://i.stack.imgur.com/uiuja.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/uiuja.png" alt="Power BI Report canvas"></a></p>
  
  <p>As I understand, this is because the Power BI Big Query connector doesn't support repeated / nested or record fields.</p>
  
  <p><strong>Question:</strong> Is there any workaround to have all columns / fields in a BigQuery table (regardless of whether they are repeated / nested / records) available for use when building Power BI reports, specifically using a live connection over the native Power BI Big Query connector?</p>
  
  <p>I do have write permissions in BigQuery so creating views on top of these tables with repeated / nested fields is possible if required as part of a solution.</p>
  
  <p>One potential workaround might be to create a view in Big Query which un-nests repeated fields and then connect Power BI to said view. Open to any workaround suggestions.</p>
  
  <p>Any help would be greatly appreciated.</p>