Scheduled Refresh Failing

Question

Hello,The scheduled refresh on one of my datasets keeps failing and i cannot for the life of me figure out why.There are two datasources on the dataset. One from an onPrem Oracle Database and one ODBC connection.The error that shows is this"Unable to connect to datasource Undefined"Underlying error message:Oracle: ORA-03114: not connected to ORACLE&nbsp;I have tried:Increasing connection time out on the oracle datasource from PBI DesktopSetting the privacy levels of both data sources to Organizational&nbsp;For some reason it still fails and i really do not know what else to do

paulusd · Answer

Hi&nbsp;HeirsPowerBi&nbsp;,&nbsp;First thing that comes to mind, have you added the sources to a gateway?&nbsp;

heirspowerbi · Answer

Yes i have other Reports that are connected to the same Oracle Data Source and are refreshing Just fine.

paulusd · Answer

and when you refresh it from within the desktop, does that run fine as well?

heirspowerbi · Answer

Yes it refreshes just fine in PBI Desktop

paulusd · Answer

then i would suggest deleting the report and the dataset in the service, refresh in the desktop and re-publish to the service.&nbsp;If that doesn't work you could try deleting the source from the gateway and re-adding that, but as you have a oracle on prem source i'm guessing that you have more reports linked to that source. This would be a last option that you probably don't want to use. it would require re-linking the source to the gateway for all reports using this source.

Forum Discussion

Scheduled Refresh Failing

8 Replies

Related content

Scheduled pipelines failing

Schedule refresh failed.

Scheduled refresh failing for postgresSQL

Schedule refresh

scheduled refresh failed