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

arify

Microsoft 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'." ?

Recent ideas

Org apps - Cannot be arranged in folders and do not stay hidden
Currently, Organizational Apps (Org Apps) are displayed in the standard Apps section of the Get Apps experience, alongside regular workspace apps. For organizations managing large-scale Power BI depl...
akonda
New Member
1 day ago
New
Views
0likes
Comments
Increase or Make Configurable the Power BI Browser Tab Limit (Currently 20 Items)
Power BI users frequently work across multiple reports, dashboards, semantic models, notebooks, and Fabric artifacts simultaneously. The current browser limitation of 20 open Power BI/Fabric items re...
sharadmahajan
Regular Visitor
1 day ago
New
Views
21likes
Comments
Please return File Close and Exit to Power BI.
Please have a way to put back File Close and File Exit in Power BI or at least make it an option as I like it and am used to it in other Microsoft applications. Copilot worded version: Power BI D...
lahuva
New Member
1 day ago
New
Views
0likes
Comments
Add "Default to Top Value" to Slicers
Scenario Currently, there's no way to easily default slicers to the first/top value, which means you have to either hardcode into reports or do some kind of data work to "invent" a default value. Th...
arpost
Post Prodigy
1 day ago
New
Views
1like
Comments
Add "NO SELECTION" default selected option to slicers
Scenario Currently, slicers have two states: No value selected (bogs report down) BI dev preselects one or more data values (problematic when reports are consumed by other clients/users) Option...
arpost
Post Prodigy
1 day ago
New
Views
0likes
Comments

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

Org apps - Cannot be arranged in folders and do not stay hidden

Increase or Make Configurable the Power BI Browser Tab Limit (Currently 20 Items)

Please return File Close and Exit to Power BI.

Add "Default to Top Value" to Slicers

Add "NO SELECTION" default selected option to slicers