Error when using search in a slicer widget.

[jeandavidt]

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

[v-xiaoyan-msft]

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

[jeandavidt]

Unfortunately, I'm not able to test the issue on Power BI service, as I don't have an on-premise gatway that would allow my dataset to be accessible from Power BI service.

Hopefully that doesn't impede your investigation too much

Best,

Jean-David