The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hello, I'm trying to import data from a Snowflake table with 500+ million rows and I'm running into below error message. Any ideas on how to handle this error.
Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [DataSource.Error] ERROR [HY000] [Microsoft][Snowflake] (25)
Result download worker error: Worker error: [Microsoft][Snowflake] (4) REST request for URL https://n6jighsfcb1stg.blob.core.windows.net/results/01ad8bb7-
0a04-baf5-0001-666e66911322_0%2Fmain%2Fdata_7_1_18?sv=2021-04-10&spr=https&se=2023-07-11T08%3A37%3A54Z&sr=b&sp=r&sig=Rw38E5B%2FmW%2FT3Ljvx8%2FYRzoZeMDK5uFU
%2BzRQ2f7JSmo%3D&rsce=gzip failed: CURLerror (curl_easy_perform() failed) - code=42 msg='Operation was aborted by an application callback'. . '.
Hi @lbendlin , I am facing the same data volume issue but I got the above error after I placed date parameters as part of incremental refresh. I am also trying to import 700million rows from a table using incremental refresh from Snowflake and I am guessing query folding is not available. So could you suggest me any solution ?
Read about bootstrapping and manual partition updates.
Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Learn
You may want to consider using incremental refresh.
User | Count |
---|---|
80 | |
78 | |
37 | |
34 | |
31 |
User | Count |
---|---|
93 | |
81 | |
60 | |
49 | |
49 |