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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @jeandavidt ,
We want to know if this problem occurs only in Power BI Desktop or also in Power BI Service?
Would you mind trying it in Power BI Service and giving us some information?
Best regards.
Community Support Team_Caitlyn