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
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.

      • HeirsPowerBi's avatar
        HeirsPowerBi
        Helper I
        3 years ago

        Yes i think i will just have to delete the report and republish from desktop. Although  i was trying to avoid that.

        Thank you so much