Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
In Power BI Desktop, I'm connecting to an Oracle data source and I've added a slicer that lists out my data. I want to be able to type the value in the Search field of the slicer so I won't have to scroll thousands of records. However, when I type in a value, I get error: ORA-00904: "t0"."<field_name>": invalid identifier". I found this article (https://community.powerbi.com/t5/Issues/Query-Error-on-Search-Field-of-Slicer-when-Using-Direct-Quer...) where this user is experiencing the same issue. However, there does not seem to be a resolution. Is there a workaround for this issue?
Solved! Go to Solution.
As a workaround, instead of creating a relative date slicer, I've created a relative date filter. So, I've added the column to filter as a "Filter on this page". This seems to be a solution for my requirement.
As a workaround, instead of creating a relative date slicer, I've created a relative date filter. So, I've added the column to filter as a "Filter on this page". This seems to be a solution for my requirement.
Under the link you provided it is said that power bi does not support oracle 11. What version are you using?
I am using Oracle 10g.
Hi @micheledubose ,
Are you using direct query connection mode?If so,it requires Oracle 12 or higher version.
See below similar thread.
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |