Hello Community, as suggested by lbendlin here [Oracle Direct Query text filter causes visual crash] i'm opening this issue. Recap: I am encountering a critical error when trying to search usin...
BogdanL
Advocate I
Advocate IHello Anonymous
Internally within the company, I conducted tests on two other systems: Oracle Database 18c and 19c. In these cases, searching a field in Direct Query works as expected. Based on this, I conclude that the issue lies with Oracle 11g. Given the age of its engine, dating back to 2007, it likely cannot handle complex context scopes.
I have opened a ticket with Power BI Support and was contacted by an engineer. Together, we agreed on an alternative solution: incremental refresh by loading of 10 years of archived history, combined with updates for the most recent day every 30 minutes from 7:30 AM to 7:30 PM.
Best Regards,
BogdanL