Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Error when refreshing dataset with bigquery

Hello,

 

I'm using powerbi gen2 and got error when refreshing a dataset with bigquery database.

 

I checked google log dashboard and can't find any more information. There is no error logged at this timestamp or around it

 

thx for the help

 

Erreur de source de données:DataSource.Error: ERROR [HY000] [Microsoft][BigQuery] (310) Storage API Error: Error: { code: UNKNOWN, message: Stream removed }. The exception was raised by the IDataReader interface. Please review the error message and provider documentation for further information and corrective action.
URI du cluster: WABI-NORTH-EUROPE-D-PRIMARY-redirect.analysis.windows.net
ID d'activité: 582cb491-83f5-4d42-81c2-218d740cdf45
ID de demande: 4e3f182d-bd50-c18d-8d82-1e5852c47608
Heure: 2023-07-05 15:55:14Z

Status: Investigating
Comments
Anonymous
Not applicable

Hi  @AdinCausevic ,

 

Based on the error message,

Do you set the values of Minimum Query Results Size for HTAPI and Ratio of Results to Rows Per Block when you enable the High-Troughput API? If not, please set them equal to the default values and try again.

If it doesn’t work, please read Quotas & limits of BigQuery, especially the Maximum number of table operations per day is 1,000.

 

Best regards.
Community Support Team_Caitlyn

AdinCausevic
New Member

Hello 

 

thank you @Anonymous for the answer

 

We are using the native bigquery connector with gen2

 

How do you configure these options ?