Skip to main content

    Issues

    Completed

    Data refresh fails when using an Oracle database if "Navigate using full hierarchy" is checked.

    Vote (1) Share
    's profile image

    on 09 Jun 2016 22:58:57

    The data refresh works in the desktop app but not in the service.

    Comments (5)
    's profile image Profile Picture

    Frankieboy on 05 Jul 2020 22:25:10

    RE: Data refresh fails when using an Oracle database if "Navigate using full hierarchy" is checked.

    I updated the client yesterday (05 of july) and still gets this message in the service:

    Oracle: This database function doesn't support the query option 'HierarchicalNavigation' with value 'true'.

    's profile image Profile Picture

    sadf sdf on 05 Jul 2020 22:23:39

    RE: Data refresh fails when using an Oracle database if "Navigate using full hierarchy" is checked.

    Looks like our latest update resolved...closing

    's profile image Profile Picture

    Power BI User on 05 Jul 2020 22:23:33

    RE: Data refresh fails when using an Oracle database if "Navigate using full hierarchy" is checked.

    Yes, the error posted by Oguz is the exact error and yes the latest version of the Enterprise Gateway works.

    's profile image Profile Picture

    Oguz on 05 Jul 2020 22:23:24

    RE: Data refresh fails when using an Oracle database if "Navigate using full hierarchy" is checked.

    Hi, what's the error message? Is it something like "This database function doesn't support the query option 'HierarchicalNavigation' with value 'true'." ?

    's profile image Profile Picture

    Miguel Llopis on 05 Jul 2020 22:23:23

    RE: Data refresh fails when using an Oracle database if "Navigate using full hierarchy" is checked.

    Could you try downloading the latest version of the Enterprise Gateway from the Download Center and trying this again?

    Thanks,
    M.