Slow data loading time on PBI with Bigquery GCP

Hi Rinn ,
Thanks for sharing your experience. Refreshing a dataset of 30 million rows and 40 columns from BigQuery in import mode taking over 5 hours does seem unusually long, especially given that there are no Power Query transformations involved.

While refresh times can vary based on network latency, gateway performance, and BigQuery's response time, such a delay might point to a bottleneck in one of these areas. In general, others working with similar volumes (tens of millions of rows) often see refresh times ranging from 30 minutes to 2 hours, depending on optimization. You might want to check if your gateway is up to date and whether any throttling or regional restrictions are impacting performance. 

Also, consider partitioning or aggregating data in BigQuery before loading into Power BI, or using DirectQuery for better control over performance. Reaching out to others for benchmark comparisons is a great idea, but you might also want to monitor query performance directly within BigQuery to pinpoint where the delays are occurring.