undefined

[Anonymous]

Hello everyone,

I'm trying to import a table for google big query in my pbi but i have this error :

Failed to save changes to server. Error returned : « Erreur OLE DB ou ODBC: [DataSource.Error] ODBC: ERROR [42000] [Microsoft][BigQuery] (100) Error interacting with REST API: Response too large to return. Consider specifying a destination table in your job configuration. For more details, see https://cloud.google.com/bigquery/troubleshooting-errors.
Erreur OLE DB ou ODBC: Exception de HRESULT : 0x80040E4E.
 what can I do please?

thanks

[v-luwang-msft]

Hi @Anonymous ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft · Accepted solution]

Hi  @Anonymous ,

Set allowLargeResults to true in your job configuration. You must also specify a destination table with the allowLargeResults flag.

refer：

https://stackoverflow.com/questions/20287938/error-response-too-large-to-return-in-big-query 

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

Best Regards,
Lucien