Skip to main content
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
tiffany1234
New Contributor

[Error] Couldn't load the data for this visual in DirectQuery mode

Hello, we are currently encountering an issue regarding data in the "Direct Query" mode: 
Within the Slicer:
If it's single selection, the visualization chart encounters the following error: [OLE DB or ODBC error: [Expression.Error] Unable to fold the expression to the data source, please try a simpler expression] (as shown in picture below).
If it's multi-selection, the visualization chart displays correctly.
May I ask what could be the cause of this issue?

ๅœ–็‰‡1.png

 

 

1 REPLY 1
lbendlin
Esteemed Contributor III

Look at the network trace .  Most likely it is messing up the IN version with a single list item.

Helpful resources

Announcements
Users online (4,086)