title: Querying BigQuery Events data in PowerBI
body: <p>Hi I have analytics events data moved from firebase to BigQuery and need to create visualization in PowerBI using that BigQuery dataset. I'm able to access the dataset in PowerBI but some fields are in array type I generally use UNNEST while querying in console but how to run the query inside PowerBI. Is there any other option available? Thanks.
  <a href="https://i.stack.imgur.com/Iallx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Iallx.jpg" alt="In PowerBI"></a>
  Table In BigQuery
  <a href="https://i.stack.imgur.com/2XyPT.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/2XyPT.jpg" alt="enter image description here"></a></p>