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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
songogeta32
Helper I
Helper I

[BigQuery] (310) Storage API Error: Error: { code: UNKNOWN, message: Stream removed }

I am getting this error for big projects which have large number of rows - 

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][BigQuery] (310) Storage API Error: Error: { code: UNKNOWN, message: Stream removed }. '.

And I am not using ODBC driver but Google Big Query connector to connect to GCP Big Query. Though I have ODBC Simba driver installed in my VM. What is the issue here?

 

I noticed one thing this error we are only facing in a shared vm(among 9 members). When I am working on a personal Azure vm then this error is not coming and data is also loading very fast. Both have same ram(32 GB) and cpu(xeon 8272cl vs 8370c) and are in same network zone. What can be issue here?

7 REPLIES 7
v-jianpeng-msft
Community Support
Community Support

Hi, @songogeta32 

Thanks @AmiraBedh . You can try the following method, which is from another case:

Re: OLE DB or ODBC error: [DataSource.Error] ERROR... - Microsoft Fabric Community

vjianpengmsft_0-1712040526499.png

You can also try clearing your cache, as you will be guided in the following article.

How to solve OLE DB or ODBC errors in PowerBI - CloudFronts

vjianpengmsft_1-1712040707330.png

 

 

 

 

 

How to Get Your Question Answered Quickly

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards

Jianpeng Li

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

@v-jianpeng-msft   I had a discussion with Google Team. They know about the issue, they mentioned that on retry this can be solved easily. But it seems like the Google BQ connector doesnt have the retry mechanism. Is this being worked upon?

Hi, @songogeta32 

Thank you very much for your reply. While there is no direct reconnect button, you can try to re-establish the connection or add credentials, you can try it.

In addition, you can try to adjust the timeout period to see if it will be reconnected within the specified time, the documentation for the advanced settings is as follows:

Google BigQuery (Microsoft Entra ID) (Beta) - Power Query | Microsoft Learn

vjianpengmsft_0-1712050715079.png

You can also try the two methods of the previous reply.

 

 

 

Best Regards

Jianpeng Li

 

https://issuetracker.google.com/issues/240305081?pli=1

Google confirmed its an open issue from their side. But the error can be handled from client side also i.e. if Google BigQuery connector implements retries in RPC API calls then this will be solved.

Also we are using Google Big Query connector then why the error is related to ODBC. We have installed odbc driver but we are not using!

No the retry logic should be inside the Google BQ connector, not for user to something to worry about. The API call inside the BQ connector should be retried.

AmiraBedh
Resident Rockstar
Resident Rockstar

You may need to post it in the issues section
https://community.powerbi.com/t5/Issues/idb-p/Issues


If you have Pro subscription, open a support ticket.Go to https://support.powerbi.com > Scroll down > "CREATE SUPPORT TICKET".


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.