Intermittent Performance Issues with BigQuery in Direct Query mode in Service

[fblissjr]

We've been intermittent luck with using Google BigQuery in Direct Query mode on the Power BI service. For as few days, it ran great, no performance issues. Suddenly after 4pm CST yesterday (12/20), we started to get severe degradation when using the service. No changes on our end, and didn't see any issues reported.

Any thoughts to what may be causing this?

[fblissjr]

We've been intermittent luck with using Google BigQuery in Direct Query mode on the Power BI service. For as few days, it ran great, no performance issues. Suddenly after 4pm CST yesterday (12/20), we started to get severe degradation when using the service. No changes on our end, and didn't see any issues reported.

Any thoughts to what may be causing this?

[v-jiascu-msft]

Hi @fblissjr,

This is a bit question. There could be many causes.

1. The network performance.

2. The size of the dataset.

3. The limitations from Google API, please check it out here if the limitations are reached.

Best Regards,

Dale