cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Intermittent Performance Issues with BigQuery in Direct Query mode in Service

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?

2 REPLIES 2
Regular Visitor

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?

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

 

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
November Update

Check it Out!

Click here to read more about the November 2020 Updates!

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform October Community Highlights

Check out the top community contributors across all of the communities

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors