Forum Discussion
238 Gb Oracle File refresh (incremental) not working
Dear Reader,
can I ask for your help? We have a 238 Gb Oracle db, that we loaded in Pbi Desktop (2mb file size). The load took around 4 hours, then we published to Service environment with Incremental refresh.
The publishing was successful, however, we are not able to refresh. We set max refresh time out to 6 hours.
| Scheduled | 9/26/2019, 10:32:43 AM | 9/26/2019, 3:33:00 PM | Failed | Before the data import for finished, its data source timed out. Double-check whether that data source can process import queries, and if it can, try again. |
| Cluster URI: | WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net |
| Activity ID: | 71f76d66-5f2a-43b4-8657-ee6d951ddf6d |
| Request ID: | 020df484-589c-4722-8665-abe617146115 |
| Time: | 2019-09-26 13:33:00Z |
Not sure if the Oracle connection handles SQL code, we tried /* Select Top (100), from Db. ...... this code did not work
We can still refresh on desktop, and publish again the latest data, however, we want to automate this. Please advise
reg martijn
1 Reply
Hi martijnth ,
You could try to connect to Oracle directly. And please set refresh table in the last several days or months (a smaller dataset), not go back with all your data to see if that would help.
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
