Big Query view loading forever

[norfecaz]

Hi Friends!

I have the following issue and I would appreciate any help.

While connecting to the view from BigQuery, it is taking forever to load, eventually ending with an error: ODBC: ERROR [HY000] [Microsoft][BigQuery] (115) Operation timeout. ExecuteRetriable.

I can add connection timeout parameter, but it still takes forever to load. In BQ it runs fast, although it queries 50GB and has 34667 rows.

Funny thing is - before it worked with no problem and it suddenly changed.

Did anyone have similar problems and solved it?

[Anonymous · Accepted solution]

@norfecaz 

You can set the timeout in the query:

• Add timeout parameter to Query argument within M Code / Advanced Editor
• [Query="SELECT ...", CommandTimeout =#duration(0,1,0,0)]

Please refer to the post: ODBC & OLE DB Timeout Errors 

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