238 Gb Oracle File refresh (incremental) not working

[martijnth]

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

[v-xuding-msft]

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.