Forum Discussion

HeirsPowerBi's avatar
HeirsPowerBi
Helper I
3 years ago

Scheduled Refresh Failing

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...
Need Help
PaulusD's avatar
PaulusD
Resolver II
3 years ago

Hi HeirsPowerBi ,

 

First thing that comes to mind, have you added the sources to a gateway?

 

HeirsPowerBi's avatar
HeirsPowerBi
Helper I
3 years ago

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

  • PaulusD's avatar
    PaulusD
    Resolver II
    3 years ago

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

    • HeirsPowerBi's avatar
      HeirsPowerBi
      Helper I
      3 years ago

      Yes it refreshes just fine in PBI Desktop

      • PaulusD's avatar
        PaulusD
        Resolver II
        3 years ago

        then i would suggest deleting the report and the dataset in the service, refresh in the desktop and re-publish to the service.

         

        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.