https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Error-Couldn-t-load-the-data-for-this-visual-in-DirectQuery-mode/m-p/3863093#M9511 <P>Look at the network trace .&nbsp; Most likely it is messing up the IN version with a single list item.</P> Tue, 23 Apr 2024 17:12:23 GMT lbendlin 2024-04-23T17:12:23Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Error-Couldn-t-load-the-data-for-this-visual-in-DirectQuery-mode/m-p/3861547#M9505 <P>Hello, we are currently encountering an issue regarding data in the "Direct Query" mode:&nbsp;<BR />Within the Slicer:<BR />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).<BR />If it's multi-selection, the visualization chart displays correctly.<BR />May I ask what could be the cause of this issue?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-center" image-alt="圖片1.png" style="width: 999px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/1084147iD88DE828F9A353F1/image-size/large?v=v2&amp;px=999" role="button" title="圖片1.png" alt="圖片1.png" /></span></P><P>&nbsp;</P><P>&nbsp;</P> Tue, 23 Apr 2024 08:18:45 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Error-Couldn-t-load-the-data-for-this-visual-in-DirectQuery-mode/m-p/3861547#M9505 tiffany1234 2024-04-23T08:18:45Z https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Error-Couldn-t-load-the-data-for-this-visual-in-DirectQuery-mode/m-p/3863093#M9511 <P>Look at the network trace .&nbsp; Most likely it is messing up the IN version with a single list item.</P> Tue, 23 Apr 2024 17:12:23 GMT https://community.fabric.microsoft.com/t5/Custom-Visuals-Development/Error-Couldn-t-load-the-data-for-this-visual-in-DirectQuery-mode/m-p/3863093#M9511 lbendlin 2024-04-23T17:12:23Z