Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello Power BI Community, I have trouble with my dataset on Power BI service. Everytime, I tried to refresh data, it showed the error below. I cant identify where this issue comes from. It happended because of oracle database, on-premise gateways, or server? I really dont what exactly issue is to troubleshoot this issue. Please help me! Thank you so much.
P.s All I know that this problem may be caused by database timeouts.
Last refresh failed: Sat Jun 03 2017 15:37:15 GMT+0700 (SE Asia Standard Time)
Underlying error code: | -2147467259 |
Underlying error message: | Oracle: ORA-01013: user requested cancel of current operation |
DM_ErrorDetailNameCode_UnderlyingHResult: | -2147467259 |
Microsoft.Data.Mashup.ValueError.DataSourceKind: | Oracle |
Microsoft.Data.Mashup.ValueError.DataSourcePath: | 10.xxx.x.xx/pdbbiaprod.domain.vn |
Microsoft.Data.Mashup.ValueError.ErrorCode: | -2147467259 |
Microsoft.Data.Mashup.ValueError.Message: | ORA-01013: user requested cancel of current operation |
Microsoft.Data.Mashup.ValueError.Reason: | DataSource.Error |
Cluster URI: | WABI-SOUTH-EAST-ASIA-redirect.analysis.windows.net |
Activity ID: | 937ac922-5292-9084-8b04-edfc1f7a440b |
Request ID: | 43eee97a-af72-a18f-484d-24476110e7ca |
Time: | 2017-06-03 08:37:15Z |
Hi Try this
If you are using open database connectivity (ODBC) in Oracle, you have the option of enabling timeouts so that you do not face this error message again. To enable timeouts, go to your Control Panel and click on Administrative Tools. In the Administrative Tools dialog box, clock data sources (ODBC). Select your ODBC connection. On the configuration page, look for the box next to “Enable ODBC Timeout” and make sure that is box is unchecked. This will prevent further timeouts from occurring.
The Oracle error message may be caused by timeouts.
To lengthen the timeout, simply enter the duration (e.g. 180) in the 'Command timeout in minutes (optional)' box, in 'Advanced options' of Data source settings :
Funcionó para mi! Increíble!!!!, tanto renegar y era tan sencillo!
Hi @ptphuy,
Have you checked this article to troubleshoot this issue?
In addition, if the issue persists, I would suggest you create a support ticket on Power BI Support for better assistance on this issue.
Regards