title: PowerBI, Live connection to Bigquery is slow, how to troubleshoot?
body: <p>I am connecting PowerBI to Bigquery view, it is slow, how to troubleshoot and understand if it PowerBI or Bigquery, I use the same view in datastudio and it is way faster.</p>
  
  <p>I attached an example here</p>
  
  <p><a href="https://app.powerbi.com/view?r=eyJrIjoiNTg5MDVjYjktZmNjMi00MzJjLWEzY2UtMTJmMTllNzI3ZTk2IiwidCI6IjdmNjhjN2QwLTc0ZTgtNGE2Ni04NGI3LWZhMjdlMzYyNTFiOCJ9" rel="nofollow noreferrer">https://app.powerbi.com/view?r=eyJrIjoiNTg5MDVjYjktZmNjMi00MzJjLWEzY2UtMTJmMTllNzI3ZTk2IiwidCI6IjdmNjhjN2QwLTc0ZTgtNGE2Ni04NGI3LWZhMjdlMzYyNTFiOCJ9</a></p>
  
  <p>in the console, I get this results</p>
  
  <p>Query complete (1.5 sec elapsed, 8.4 MB processed)</p>
  
  <p>I know there is an overhead to download the data from BQ to PowerBI, but it seems very slow for such a small data</p>