Hi,
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!
Cheers,
JD
Feedback Type:
Frown (Error)
Timestamp:
2023-05-26T15:53:55.5401007Z
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]
Peak Virtual Memory:
104 GB
Private Memory:
1.38 GB
Peak Working Set:
1.59 GB
IE Version:
11.789.19041.0
User ID:
0679fafa-cc4d-4b34-b641-5a22974e09ac
Workbook Package Info:
1* - fr-CA, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
Composite
Model Version:
PowerBI_V3
Enabled Preview Features:
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_useModernFormatPane
PBI_sparklines
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_dynamicParameters
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_lineChartError
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
on:
Power BI Desktop issues starting March 2025 releas...
SamWiseOwl
on:
Default to Current Date