cbyers's avatar
cbyers
New Member
10 years ago
Status:
Completed

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

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

6 Comments

  • cbyers's avatar
    cbyers
    New Member
    6 years ago
    Yes, the error posted by Oguz is the exact error and yes the latest version of the Enterprise Gateway works.
  • fbcideas_migusr's avatar
    fbcideas_migusr
    New Member
    6 years ago
    Could you try downloading the latest version of the Enterprise Gateway from the Download Center and trying this again? Thanks, M.
  • arify's avatar
    arify
    Icon for Microsoft Employee rankMicrosoft Employee
    6 years ago
    Hi, what's the error message? Is it something like "This database function doesn't support the query option 'HierarchicalNavigation' with value 'true'." ?
  • chass's avatar
    chass
    Icon for Impactful Individual rankImpactful Individual
    6 years ago
    Looks like our latest update resolved...closing
  • frank33's avatar
    frank33
    New Member
    6 years ago
    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'.

Recent ideas