- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
Error when using search in a slicer widget.
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.
- Pranav13 on: Unable to sort months in PowerBI
-
mattlee on: “Add Value” in Textbox Not Visible in Dark Theme
- mattin on: Report Server Permissions Jan/May 2025
-
bhalicki
on: Bi Crashes on launch with (AS Process PID=XXXXXX H...
- stanteitelbaum on: authenticator wont trigger after purchase of new p...
-
Stinkys
on: Fix the Date function in DAX
-
Stinkys
on: Cannot login to community site
-
reubwork
on: May 25 update for Snowflake Connector v2 has broke...
-
dmkblesser
on: Unable to open existing PBIP files
- DamoUK on: Gateway issues
- New 8,018
- Needs Info 3,502
- Investigating 3,602
- Accepted 2,088
- Declined 38
- Delivered 3,970
-
Reports
10,227 -
Data Modeling
4,129 -
Dashboards
4,111 -
Report Server
2,114 -
Gateways
2,112 -
APIS and Embedding
1,964 -
Custom Visuals
1,787 -
Content Packs
523 -
Mobile
354 -
Need Help
11 -
Show and Tell
3 -
General Comment
2 -
Tips and Tricks
1 -
Power BI Desktop
1