This is my first post in the community, I hope this is the right place to write down this issue!
My data model is connected to an Oracle databse using DirectQuery.
I built a visual using columns from the data model without any issue. However, if I take one of the columns used in my visual, create a slicer widget, toggle on the search function, and type anything in the search box, the slicer widget crashes.
The error message is "ORA-00904: "<table name>.<column name>": invalid identifier. The exception was raised by the IDbCommand interface". That sounds weird to me, because the table and column definitely exist: they work perfectly fin in my other visuals.
Any help you might offer with this issue would be amazing, thanks in advance!
Feedback Type: Frown (Error)
Local Time: 2023-05-26T11:53:55.5401007-04:00
Session ID: 12eedd82-3a3e-4c44-8900-a0c85f5afa0c
Release: March 2022
Product Version: 2.103.881.0 (22.03) (x64)
OS Version: Microsoft Windows NT 10.0.19045.0 (x64 fr-CA)
CLR Version: 4.7 or later [Release Number = 528372]