Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

catleen

BigQuery refresh timeout

Submitted by on ‎08-19-2021 05:32 AM

Hi!

 

We have one PowerBI dataset that takes data from Google BigQuery. As of a few weeks ago we started getting timeout errors during scheduled refresh. Some days it runs through (about 20min), other days it gives a timeout error. No regularity between errors and no errors also in Google side.

Usually the manual refresh goes through, but a few days ago when I wanted to refresh the dataset in Desktop it was stuck in load mode and never load the data. When I tried to create a new report with just one table that is ~18k rows in BQ, it showed ~99k rows during refresh and was stuck at load. 

Is there some issue with the BigQuery connector?

catleen_0-1629376260202.png

 

 

Thanks

Status: New
See more ideas labeled with:
6 Comments (6 New)
Comments
v-yingjl
Community Support
Community Support
‎08-19-2021 06:45 PM

Hi @catleen ,

Simliar issue has been sumbited internal(ICM: 253715380).

Currently the temporary workaround from PG is that try to (re)configure the gatway for BigQuery refresh.

 

Would update here as soon as possible if there is any new progress about this issue.

 

Best Regards,
Community Support Team _ Yingjie Li

catleen
Frequent Visitor
‎08-23-2021 02:02 AM

Hi @v-yingjl, thanks for the reply.

But cloud datasets don't need gateways. Does the workaround mean using "Basic" authentication method and Google Service account in Power BI admin center? 

Thanks!

v-yingjl
Community Support
Community Support
‎08-23-2021 11:54 PM

Hi @catleen ,

Yes, cloud data sources do not need gateway indeed. But you can configure a gateway for it when necessary, it is optional.

a.pngaa.png

 

Best Regards,
Community Support Team _ Yingjie Li

sixtysixa
Regular Visitor
‎09-02-2021 09:30 PM

@v-yingjl is there any documentation around when the decision to use the Gateway should be employed?

catleen
Frequent Visitor
‎09-06-2021 02:15 AM

Hi @v-yingjl!

Has there been any update on the issue?

We have been trying the scheduled refresh with the Gateway and sometimes we still get a timeout error. 

Before the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again.  

Thanks!

Anonymous
Not applicable
‎09-10-2021 03:15 AM

Hi all,

 

I have a similar problem: timeout when I'm trying to refresh or when I'm trying to connect to a specific BG table (infinite loading at ~99k rows).

 

Any news about how to solve this issue (other than using the gateway) ?

 

Thank you!

Idea Statuses