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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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 ?